for level 2 (126.96.36.199) I know the formula for the baseline forecast is the following. However, would someone be able to go through the intuition behind this with me? My original formula was much more simple and it made more sense, but it was way off.
IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN OFFSET(Final Forecast, -52, 0)ELSE 0