Calculating Cumulative with Local Members in IBP

[sourojit_pal]

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

[ayanbishnu1981 · Accepted solution]

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

[former_member328640]

Hello,

Have your found an answer to your question?

Have a nice day,

Mihaela Lit