Cumulative calculation through EPM Format ?

[anamika_mudgal]

Can someone please help me to achieve cumulative calculation through EMP FORMAT in IBP Or is there is alternate solution ?

Thanks In Advance.

[Alecsandra]

Hi Ana,

Try this formula:

=INDIRECT(ADDRESS(ROW()-1,COLUMN())) + IF(COLUMN()=9*,0,INDIRECT(ADDRESS(ROW(),COLUMN()-1)))

*number corresponding to the first column of data

Best

Alecsandra

[anamika_mudgal]

Hi Alecsandra,

Thanks for your reply.

Unfortunately i could not understand the formula. I created a local member with column axis and put the formula in it but got no value.

I am trying to achieve below requirement. Here KF2 is cumulative calculation.

Can you please suggest the calculation and steps i need to follow?

Br,

Ana