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)

Answers

  • 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

  • IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0

     

    This formula worked for me