Update Historic Volumes for Baseline Forecast SPRINT-2

Options
SrishtiGoel31
SrishtiGoel31 Member, ALL USERS Posts: 5 Occasional Contributor
in Planning & 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:

Categories