Update Historic Volumes for Baseline Forecast

rmat066sysf
rmat066sysf
in Modeling

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)

Tagged:

Answers

  • anirudh
    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
    jjayavalli

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

     

    OFFSET(Volumes, -1, 0)

     

    Thank you

    Jaya

  • RaghuMulki
    RaghuMulki

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

     

    This formula worked for me

  • AnnaYalovva
    AnnaYalovva

    me too @RaghuMulki

Categories