CODEWITHSUNDEEP
hyperion
Carsten I
Carsten I

Reputation: 43

Hyperion cumulatively calculate data

im new to Hyperion and i have a Problem with some Data.

I do not want to cumulatively calculate data instead I would like to use the differences of the two consecutive values to make evaluations.

Example:

Start:           100
                 200
                 300

The result should be 200 and not 600 is this possible? And if yes how?

Thanks!

My Hyperion Version: 11.1.2.0000

Upvotes: 0

Views: 81

Answers (1)

undrline - Reinstate Monica
undrline - Reinstate Monica

Reputation: 576

It sounds like this is what you're looking for:

Value  Difference   strDifference     Output   strOutput
100    0            0                 0        0
200    100          200-100 = 100     100      0+100 = 100
300    100          300-200 = 100     200      100+100 = 200
150    -150         150-300 = -150    50       200+(-150) = 50

So, the formula for the column Difference is:

if(Prior(Difference)==null) {0} 
else {Value-Prior(Value)}

And, the formula for the column Output is:

if(Prior(Difference)==null) {0} 
else {Prior(Difference)+Difference}

Unless you want the total to be the Output in which case it's more simple:

Sum(Difference)

Sort order matters, obviously.

This is highly inefficient; if your dataset is large, Hyperion will take a long time to process the section, if it finishes at all.

Upvotes: 0

Related Questions