Skip to Content
avatar image
Former Member

Cumulative calculation through EPM Format ?

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

Thanks In Advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 05, 2016 at 12:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 05, 2016 at 05:28 PM

    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


    Add comment
    10|10000 characters needed characters exceeded