2.4.4.1 Update DEM03 Demand Forecast Module

drathod
Occasional Contributor

2.4.4.1 Update DEM03 Demand Forecast Module

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

1 ACCEPTED SOLUTION

Accepted Solutions
anand.shekhawat
Super Contributor

Re: 2.4.4.1 Update DEM03 Demand Forecast Module

@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

 

 

View solution in original post

1 REPLY 1
anand.shekhawat
Super Contributor

Re: 2.4.4.1 Update DEM03 Demand Forecast Module

@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

 

 

View solution in original post