Update Historic Volumes for Baseline Forecast

[rmat066sysf]

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)

[anirudh]

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

[jjayavalli]

In DAT03 Historic Volumes for 1st Forecast Year the formula that I used is the following:

OFFSET(Volumes, -1, 0)

Thank you

Jaya