As per process I have created DEM03 Demand Forecast Module. It shows FY20 data but FY21 data is missing in the data. Could anyone please assist me If I am wrong anywhere.
Please refer below screenshots.
I got below output -
In DEM03 , for line line item baseline forecast , you are only calculating the volume for first year forecast and for other years it's 0. So update the formula to calculate for next forecast years.
Based on your formula, you are checking what weeks are connected with the 1st year forecast (IF 'SYS01 Time Settings By Week'.'1st Forecast Year?') and giving them some values (THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year').
As you can see, you are defining what is out of the scope as 0 (ELSE 0), which means that you need to connect the data from the "Default Forecast" in the previous year with your next year (LAG or OFFSET).
Hope that helps!
can you please confirm the formula here
Can you please confirm the formula once