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? 




  • 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


  • 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!

  • Try below it will works

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