Level 2 2.3.10 Activity: Create Demand Forecast


I am checking my answers at the end of this lesson and realize that I do not have any data populating for FY21 (attached).  I have included my formulas and looking for any help and guidance on this issue.




  • Karthik31
    edited November 2022



    For Baseline Forecast try using the formula mentioned below: 


    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)



    DATA03 Historic volumes 

    keep the summary as SUM for both line items


  • @stephaniejlw 


    Dem03 in the supply chain should look like below. I would check your module blueprint view settings and you data; have you done previous tasks correctly? There is no time range use in dem03. Please see model calender settings.



    Screenshot 2022-11-03 at 09.13.10.png

    Screenshot 2022-11-03 at 09.12.46.png