Level 2 Sprint 2- Baseline Forecast line item

JoanneN

Hi everyone, 

 

I have an issue with the formula for Baseline Forecast in this module-

 

Here is my error message: 

"For function OFFSET, all line item arguments that vary by time must use the same Time Range as the result line item.
Result line item 'DEM03 Demand Forecast'.Baseline Forecast uses Time Range Model Calendar. But line item 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' uses Time Range FY19-FY20." 

 

Am I using the right source? Should I change the time range of the forecast? 

 

Thanks! 

Abhiram K

Hi Joanne,

 

You are going right ,and close.

It is not needed to change the time range for forecast.

Hint: Check and Rewrite the formula for baseline forecast based on.

1. SYS01 module

2. Offset function

3. DATA03 historical Volumes 

 

Hope this helps

~Abhi