Calculate rolling 15 Weeks of Average - Keyfigure Calculation in IBP

[SatishWaghmare]

Hello All,

How to calculate rolling 15 Weeks of Average of Consensus Demand Keyfigure from Current Week and future weeks?

• 15 Weeks of Average of Consensus Demand Keyfigure for CW = Average (Consensus Demand(CW-1), Consensus Demand(CW), Consensus Demand(CW+1),..........., Consensus Demand(CW+13) )
• 15 Weeks of Average of Consensus Demand for CW+1 = Average (Consensus Demand(CW), Consensus Demand(CW+1), Consensus Demand(CW+2),..........., Consensus Demand(CW+14) )

• AND So on for all future weeks.

• Note : CW stands for Current Week in above formula.

It needs to be a calculated keyfigure. May be IBP_CAGGR function to do the calculation across time periods. We do not like to use any workaround like running Forecast model to create average 15 weeks demand.

Please let me know incase you require any additional information.

Thank you for your input and help.

Satish Waghmare

[Irmi_Kuntze · Accepted solution]

IBP_CAGGR is not rolling, you are trying the wrong operator

Search the model config guide for IBP_RAGGR in chapter 14.8.3 Rolling Aggregation, you‘ll find an example and detailed explanation there

[SatishWaghmare]

Yes, it worked fine. Thank you

AVGFCST@CALWKPRODLOC=IBP_RAGGR("FCST@CALWKPRODLOC",''AVG'',-1,15,''PASTCURRENTFUTURE'')