# 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)  Please suggest
Tagged:

•

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