Level 2 2.3.10 Activity: Create Demand Forecast

Options

Hi,

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.

 

Thanks,
Stephanie

Comments

  • Karthik31
    edited November 2022
    Options

    Hi, 

     

    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)

    and 

     

    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.

    Ravinder

     

    Screenshot 2022-11-03 at 09.13.10.png

    Screenshot 2022-11-03 at 09.12.46.png