Forum Discussion

rchaturvedi27's avatar
rchaturvedi27
New Contributor II
5 months ago

Calculations on a Cube view dependent of column

Hi, 

I would like to perform a financial calculation based on the current and previous quarter values, then returns the result.

I have created the following layout of the cube view.

I would like to do calculations such as ( previous Q amount + Current quarter account ) *2 for an account  should be the value of the row 2. However, I am unable to achieve this because , I would like to do this for all the Q columns and then the POV changes. for example. Q3 calculations would be ( Q3 actuals + Q2 ( prior q) actuals ) *2 and similarly the change would be observed in Q3 results. Get Data Cell is not possible I assume here because of dynamic column usage. Is there any other simpler way other than the use of XFBR?

Cube View
  • TheJonG's avatar
    TheJonG
    Contributor III
    5 months ago

    Hi - I am not sure I am following 100% but you could try a dynamic calc stored in a UD8 member. The formula would determine the prior quarter based off the api.pov.time.name which would be whatever the time value is of each column. So it would work on any set of columns because the dynamic calc will execute for each cell and pickup the time period from that cell (which appears to be a different quarter).