2.4.4.1 Update DEM03 Demand Forecast Module

drathod

Hi,

 

for level 2 (2.4.4.1) I know the formula for the baseline forecast is the following. However, would someone be able to go through the intuition behind this with me? My original formula was much more simple and it made more sense, but it was way off.

 

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN OFFSET(Final Forecast, -52, 0) ELSE 0

anand.shekhawat

@drathod 

The below formula is very precise and written keeping best practices in mind.

There are multiple other ways to achieve the same functionality in Anaplan. Glad you found another way of doing this.

 

~Anand