Update Historic Volumes for Baseline Forecast

Highlighted
Occasional Contributor

Update Historic Volumes for Baseline Forecast

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)

1 REPLY 1
Highlighted
Master Anaplanner/Community Boss

Re: Update Historic Volumes for Baseline Forecast

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