L2 Sprint 2 - 2.3.9 Activity: Historic Volumes to Baseline Forecast

ltalston
ltalston
edited March 18 in Academy Discussions

Hello, I keep seeing the following error message:

Invalid formula:

'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' = IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET('DEM02 Volume Growth Rates by Week'.Growth %, -52, 0) ELSE 0

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 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' uses Time Range FY19-FY20. But line item 'DEM02 Volume Growth Rates by Week'.Growth % uses Time Range Model Calendar.

The error message is explaining the error but I'm not sure if the Time Range for DAT03 should be changed to FY19-FY20 or if DEM02 should be changed to the Time Range Model Calendar. DEM02 is a duplicate of DEM01 so then would I need to change that time range as well? And then modify the time range model calendar to include prior year?

Tagged:

Categories