Update Historic Volumes for Baseline Forecast SPRINT-2

SrishtiGoel31
Occasional Contributor

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
1 REPLY 1
anand.shekhawat
Valued Contributor

Re: Update Historic Volumes for Baseline Forecast SPRINT-2

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