Update Historic Volumes for Baseline Forecast SPRINT-2
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)
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.