Skip to Content
0
May 28, 2020 at 05:47 PM

Calculate rolling 15 Weeks of Average - Keyfigure Calculation in IBP

406 Views Last edit May 28, 2020 at 05:49 PM 2 rev

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