DAT03 Historic Volume

 

Hello,

On DAT03 Historic Volumes my volume line item don't match with the values for FY20 but does match with Offset volumes for Fy20. I used the following formula:

 

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0.

And, also DEM03 demand forecast pulls only FY20 data not FY21, used the attached time settings:

 

Please suggest.

 

Thanks,

 

 
 

 

 

 

 

 

Comments

  • Hi @Sangya 

     

    Your time settings are correct, In DAT03 Historic volumes, The Offset volumes match the data for only the FY20, not for FY19, and Volumes match only FY19 and not for FY20 (i.e For FY20 you get values like 0 for Volumes). It is because of the time setting in 'SYS01 Time Settings By Week'. 

     

    Your formula for offset volume is correct.

     

    Since you have set 'Number of future years' to 1, you should be able to access to FY21.

     

    In DEM03 Demand Forecast, Go to blueprint view and set Time scale to Week and Time Range to Model Calender

     

    Thanks,

    Nivetha K 

  • Thank You.. The time Range in my DEM03 modules was FY19-20 and after I changed it to Model Calendar, it is all set..

     

     

  • i'm getting the same error, even after In DEM03 Demand Forecast, i have already set Time scale to Week and Time Range to Model Calender

     

    DEM03 Demand Forecast:

    robinsonb6_0-1624374469896.png

    DAT03 Historic Volume:

    robinsonb6_1-1624374509789.png

    SYS01 time settings by Week:

    robinsonb6_2-1624374613183.png

    could you please let me know where i need to correct to get the FY21calendar like below:

     

    robinsonb6_4-1624374726540.png