Highlighted
Occasional Contributor

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,

 

 
 

 

 

 

 

 

2 REPLIES 2
Highlighted
Contributor

Re: DAT03 Historic Volume

Hi @Sangya1 

 

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 

Highlighted
Occasional Contributor

Re: DAT03 Historic Volume

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