cancel
Showing results for 
Search instead for 
Did you mean: 

NEWBIE question regarding calculations in a layout

Former Member
0 Kudos

Hi Experts:

I need to create a layout to show actuals vs. forecasted/planned data. The actuals contain data from past 6 months and planned contains rolling forecast of the next18 months. The values for the forecasted months will be calculated based on the values from the previous month. For example: March's forecasted value is based on February's and February's is based on January's. How do I go about achieving this? I am using Key Figures in Lead Column and offsetting variables.

If someone can point me in the right direction, it will be greatly appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

former_member93896
Active Contributor
0 Kudos

Hello Jane,

you can do this calculation with a formula (FOX) planning function. Basically you would use DO...ENDDO to loop over the months. You can use a variable to define the starting month for example.

Regards

Marc

SAP NetWeaver RIG

Answers (0)