Hi,
I have used below offset formula.
IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0
I am getting all zeros also my volume line item data got blank. At first I was able to see data. But now both the line items showing data as 0.
Could anyone please help me. refer attached screenshots. Also please elaborate how we have used offset function in formula.


Thanks in Advance.