Level 2 Sprint 2- Baseline Forecast line item

Highlighted
Occasional Contributor

Level 2 Sprint 2- Baseline Forecast line item

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! 

3 REPLIES 3
Highlighted
Regular Contributor

Re: Level 2 Sprint 2- Baseline Forecast line item

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

Highlighted
Super Contributor

Re: Level 2 Sprint 2- Baseline Forecast line item

Hi @JoanneN,

 

I do not think that Time Range would cause an issue. Try to think about your formula, your correctly reference 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' as your source, but you are missing something. Look into time settings system module! Hope this will help you figure it out.

 

Feel free to reach out in case of questions!

Highlighted
Occasional Contributor

Re: Level 2 Sprint 2- Baseline Forecast line item

Try below it will works

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