Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  Pax Exploration View - Insert Calculation Issue

    Posted Fri December 11, 2020 06:07 PM
    I'm trying to insert calculated row in exploration view in pax. Unfortunately it only allows you to insert summation or multiplication of selected rows.. Wondering How I can insert a bit complex formula.. Appreciate your Help! thanks

    ------------------------------
    Aleksandre Metreveli
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Pax Exploration View - Insert Calculation Issue

    Posted Mon December 14, 2020 10:24 AM
    Aleksandre,

    I would suggest simply using an Excel formula which can be preserved and refreshed with the report by performing the following actions.

    1. Using the PAfE context menu, insert a user row on the rows axis. 
    2. In the first data cell of the row, enter the desired Excel formula calculation.
    3. Open the PAfE options and enable the 'Preserve user formulas' option

    A refresh will now propagate the formula across the entire row and will be preserved across future refreshes.

    ------------------------------
    Matt Hopkins
    Senior Software Engineer
    QueBIT Consulting
    ------------------------------

    Original Message


  • 3.  RE: Pax Exploration View - Insert Calculation Issue

    Posted Mon December 14, 2020 12:14 PM
    Thank you Matt! appreciate your help!

    ------------------------------
    Aleksandre Metreveli
    ------------------------------

    Original Message


  • 4.  RE: Pax Exploration View - Insert Calculation Issue

    Posted Tue December 15, 2020 01:34 PM
    Arbitrary (server side) calculations can also be defined using the 'mdx' dialog associated with Exploration Reports, as well as some additional options if you compose in the pop up viewer and then convert to an exploration.  Admittedly, it is a bit sophisticated to use; I'd suggest making a 'placeholder' calc, and then modifying it as needed.

    This is an area we are looking to improve on in the future.

    ------------------------------
    Ted Phillips
    ------------------------------

    Original Message