Highlighted
Certified Master Anaplanner

Level 2 - Sprint 2 - DEM03 Module

Hi Team,

 

Great work with the training!

 

I am not sure if anyone has brought this to your attention:

 

In the directions for creating the calculation for the Baseline Forecast line item, It is asked that for the FY21 periods to use the FY20 "Initial Demand Forecast" (see screenshot below). The explanation in the parenthesis as well as the example below it, identifies this calculation as the "Default Forecast". 

 

Thanks,

 

-Tasos 

 

Screenshot_1.jpg

1 REPLY 1
Highlighted
Occasional Contributor

Re: Level 2 - Sprint 2 - DEM03 Module

Hello Tasos,

 

We need to build a module using a time dimension

 

In the calculation of "Baseline Forecast" For FY20 we need to use the historical data(FY19) to calculate  FY20 period.

For FY21 we need to use the FY20 base data to calculate the FY21 Baseline Forecast.

 

Formula.

Baseline Forecast:

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

 

Please Let me know if this helps.

 

Regards,

Parmod