2.3.10 Activity: Create Demand Forecast_unable to see FY21 data

SupriyaH
Contributor

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

3 REPLIES 3
rishabh01
Frequent Contributor

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.

BrunoRodriguez
Regular Contributor

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!

Best,
Bruno Rodriguez
SupriyaH
Contributor

@ BrunoRodriguez
Yes, I have updated formula and got required output.
Thanks.