Rolling Calculation to calculate backlog

[deveshbohre]

Dear All,

I have an specific requirement where the backlog is been calculated using 2 different input and its own last period value .

i am trying to use IBP_RAAGR function but its not giving me the result,

also KF1/KF2 having base planning at TW level but we need the values in WK level , which means even if TWa and TWb values must be same in WK level.

any best and working option for this? i dont want VBA code for this calculation.

Thanks

[piyush_parekh · Accepted solution]

Hi Devesh,

Try this out : Define KF3 = KF1 - KF2. Target KF = IBP_CAGGR(KF3,SUM,FORWARD,CURRENT&FUTURE)

Define above calculations at CW level.

Regards,

Piyush

[deveshbohre · Accepted solution]

Thanks Piyush,

This worked.