Skip to Content

Calculating Cumulative with Local Members in IBP

Hi Experts,

HOw is it possible to calculate Cumulative with the help of Local Members?

I am using Excel Addin: 6.4 however the formulas involving "Address", "Column" etc doesn't seem to be respected. Also I have tried out the samples in following threads however did not find any success:

https://archive.sap.com/discussions/thread/3834179

https://answers.sap.com/questions/76194/cumulative-calculation-through-epm-format.html

Need a quick help on this.

Regards,

Sourojit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 07 at 07:03 AM

    capture.pngHi Sourojit

    It is absolutely possible to do cumulative calculation in local KF. In-fact I have done the same few days back. But you need to keep in mind few things.

    1) I have used the excel formula =IF(ISNUMBER(J6),K5+J6,K5), where J6 is the name of the local KF and K5 is the first bucket of the source KF which should be used as a reference for cumulation.

    2) Make sure that the "attached to" option in the local member setting is just below the reference KF. Refer to my screenshot.

    3) Make sure non one changes the sequence of the KF's . You can add new KF's but make sure nothing gets added above the reference KF.

    Regards

    Ayan Bishnu

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 05 at 01:56 PM

    Hello,

    Have your found an answer to your question?

    Have a nice day,

    Mihaela Lit

    Add comment
    10|10000 characters needed characters exceeded