Update Historic Volumes for Baseline Forecast SPRINT-2

SrishtiGoel31
SrishtiGoel31
in Modeling
 
The formula for 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' is invalid:

Datatypes do not match for 'IF' function: NUMBER, BOOLEAN
 
 
I used the formula IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET('SYS01 Time Settings By Week'.'2nd Forecast Year?', -52, 0)
 
 
Please suggest
Tagged:

Answers

  • anand.shekhawat
    anand.shekhawat

    Hi @SrishtiGoel31 

     

    The logic that you have written is incorrect.

    The IF part of the formula gives the output in NUMBER format and the Else part gives the output in a BOOLEAN format.

    Kindly have another look on the requirement and try writing the formula again.

     

    ~Anand 

    https://in.linkedin.com/in/anand-shekhawat-35645486

Categories