Level 2 Sprint 2- Baseline Forecast line item

Options
JoanneN
JoanneN Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor
in Anaplan Community

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! 

Tagged:

Comments

  • mohanjmb
    mohanjmb Member, ALL USERS, Community Member, Certified Model Builder Posts: 4 Occasional Contributor

    Try below it will works

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

Categories