2.3.10 Activity: Create Demand Forecast_unable to see FY21 data

Hi,

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.

required output- 

SupriyaH_2-1657530038211.png

I got below output - 

 

SupriyaH_0-1657529853580.png

SupriyaH_1-1657529960869.png

Comments

  • Hi, @SupriyaH 

    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.

  • Hello SupriyaH,

     

    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!

    Kind regards,

    Bruno Rodriguez

  • @ BrunoRodriguez
    Yes, I have updated formula and got required output.
    Thanks.
  • @ BrunoRodriguez
    can you please confirm the formula here

  • @SupriyaH
    Can you please confirm the formula once