2.3 DAT03 Historic Volumes

SeanDW
New Contributor

2.3 DAT03 Historic Volumes

Hi,

I have historic figures for volume in DAT03 for FY19 that have been offset to give me baseline forecast for FY20.

How do I achieve the same for baseline forecast in FY21 as currently my baseline demand ends at Dec 2020. chart.jpeg

I also cannot seem to enter the ROUND formula correctly in DEM03 to get the Initial Demand Forecast? Hence why in my graph, IDF is zero.

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
JussiLi
Frequent Contributor

Re: 2.3 DAT03 Historic Volumes

Hi @SeanDW

 

For FY21 baseline you need to use FY20 Dedault Forecast (marked with green in snip below). 

JussiLi_0-1616186805444.png

For that you have to use IF statement in 'Baseline Forecast' line item; in case of 1st forecast year, take data from DAT03 module, else take it from 'Defaulf Forecast' line item. For 1st forecast year setting you need to use Time settings by week system module. When you take FY20 Default Forecast to FY21 you need OFFSET function so that value in Week 1 FY21 is fetched from Week 1 FY20 etc. 

 

Initial Demand Forecast is Default Forecast rounded UP to a whole number: ROUND(line item, 0, UP). 

 

Regards,

JussiLi

View solution in original post

2 REPLIES 2
JussiLi
Frequent Contributor

Re: 2.3 DAT03 Historic Volumes

Hi @SeanDW

 

For FY21 baseline you need to use FY20 Dedault Forecast (marked with green in snip below). 

JussiLi_0-1616186805444.png

For that you have to use IF statement in 'Baseline Forecast' line item; in case of 1st forecast year, take data from DAT03 module, else take it from 'Defaulf Forecast' line item. For 1st forecast year setting you need to use Time settings by week system module. When you take FY20 Default Forecast to FY21 you need OFFSET function so that value in Week 1 FY21 is fetched from Week 1 FY20 etc. 

 

Initial Demand Forecast is Default Forecast rounded UP to a whole number: ROUND(line item, 0, UP). 

 

Regards,

JussiLi

View solution in original post

SeanDW
New Contributor

Re: 2.3 DAT03 Historic Volumes

That is great, thank you.