Level 2 Sprint 2- Baseline Forecast line item

JoanneN
JoanneN
in Academy and learning discussions

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! 

Comments

  • abhi1017
    abhi1017

    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

  • filip.sypniewski
    filip.sypniewski

    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!

  • mohanjmb
    mohanjmb

    Try below it will works

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

Categories