Hi
Im trying to build the volumes for baseline forecast and below is my formula resulting in the following error
IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast Year',-52,0)
Appreciate your help.
Thanks in advance
The formula for 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' is invalid:
'Offset Volumes for 1st Forecast Year' = IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast Year',-52,0)
Try this formula:
Offset Volumes for 1st Forecast Year' = IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast Year',-52,0)
ELSE 0
Basically you need to close off the IF loop with a final else condition
Regards,
Anirudh
In DAT03 Historic Volumes for 1st Forecast Year the formula that I used is the following:
OFFSET(Volumes, -1, 0)
Thank you
Jaya