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

Comments

ChrisMullen

Thank you @Tasos I have fixed this in the course. It should reflect the Default Forecast.

Tasos

Thank you, Chris!

VarunN

Hi All,

I've got the formula like so for DEM03 which addresses all the answers on Question 7 (including Week14 FY21) questions. However, it does not seem to work on the final question.

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Baseline Forecast * (1 + Growth rate %), -52, 0)

The instructions specifically call for baseline in FY21 to pick up FY20 plus applicable growth rates. Any help will be much appreciated!

LinaCorrea

I think is because you're using the baseline forecast plus growth rate in the OFFSET formula. I've used the final forecast instead, and it seems to work for F21, because the final forecast for 2020 is the baseline for 2021
Hope it works for you

SRoberts

Thank you @LinaCorrea! I was stuck on that second year. Great thinking!

Quick Links

Recent release news

May 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our May 2025 official release notes. The information below offers supplemental information to that post. Integrations and extensibility Preview dataset when mapping to model or selecting for transformation view in ADO When selecting a dataset to map to a…
April 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2025 official release notes. The information below offers supplemental information to that post. UX New UX for Models section in Administration The Models section in Administration has been redesigned with a more intuitive interface. Tenant…