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.
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 items1
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.