Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Macro to calculate Cumulative in SNP Planning Book

Hi,

There is one keyfigure example ("Forecast") in SNP which is in weekly bucket .Assume I need cumulative for the forecast and result should be put into Another Key Figure ("Cumulative forecast")

For example

Data in Keyfigure " Forecast" ---Calculatin starts from 05/01/2009

05/01/2009100 05/08/2002000 5/15/200300 05/22/200400 05/29/200--500

06/05/2009 --100 06/12/2009 --0 06/19/2009 5000 06/26/20091000

The cumulative for Keyfigure 02- Cumulative forecast should look like

05/01/2009100 05/08/2009300 05/15/200600 05/22/2001000 05/29/200--1500

06/05/2009 --1600 06/12/2009 --1600 06/19/2009 6600 06/26/2009 7600

/I wrote a macro for each cell which is very long .Is there any simle steps for this.

Thanks and Regards

Raghavendra Pai

Former Member
Not what you were looking for? View more on this topic or Ask a question