Hi
I am having trouble with the formula creation ,Please help
I am using the below formula :
IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes,-52,0) ELSE IF ('SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN OFFSET('Offset Volumes for 1st Forecast Year',-52,0) ELSE 0
I am getting an error as invalid formula.
please help.
Regards,
Ankita