2.3.10 Activity: Create Demand Forecast
IF 'SYS01 Time Settings By Week'.Current Period? THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE 52
Baseline Forecast formula
'DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family]
Growth % formula
Baseline Forecast * (1 + Growth Rate %)
Default forecast formula
Intial Demand Forecast formula correct Plz help
You're close, very close. Let's take a closer look at that first formula.
- Any time you use a conditional statement, you always want to use the most likely case first so Anaplan will exit the calculation sooner. This helps with optimization. So use the NOT statement.
- If the first condition is met (not the first forecast year) then it must be the second forecast year and we need to move the first year forecast forward 52 weeks. We use the LAG function to do this.
- To be safe, use the STRICT variable in the LAG function to ensure you don't apply this function if the calendar falls outside the range.
- If the week is in the first forecast year then lets grab the historic volumes that we set up in DAT03.
IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0, STRICT) ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year'4