Skip to Content
0

Cumulative calculation through EPM Format ?

Dec 05, 2016 at 04:28 AM

112

avatar image

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

Thanks In Advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Alecsandra Dimofte
Dec 05, 2016 at 12:08 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Ana M Dec 05, 2016 at 05:28 PM
1

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



capture.png (1.7 kB)
Share
10 |10000 characters needed characters left characters exceeded