SAP APO Demand Planning Macro

[former_member1199409]

Hi All,

I have to create a macro and looking for the right function or method as I checked the standard couldn't find.

I have 2 key figures example.

Key Figure 1 (Day) Manual: 5 6 12 10 12 7 (6 periods)

Key Figure 2 (Demand) Manual: 120 110 104 99 120 90 (6 Periods)

Output Key Figure 3:

For the Current month the Day period is 5 it needs to add 5 periods of the Demand sum which is (120+110+104+99+120): 553 should populate in the current month

For the next month Day period is 6 it has to be rolling 6 periods sum (110+104+99+120+90+0): 523 should populate in the next period.

Please let me know thank you so much in advance!

Many Thanks,

Niha

[thomas_schulze2]

Hello,

use the PARTIALSUM() function - it allows to sum up number a dynamic number of cells / columns where. See function help here: SCM-APO macro functions. Important is to pass on the area (not the row!) to be summed up and please use as reading area the option "whole table" - otherwise it wont work properly.

Regards

Thomas