I'm getting a circular reference while using the OFFSET function, but I don't understand why.
(1) IF offset_value = -12 THEN OFFSET(Gross Revenue, -12, 0) ELSE OFFSET(Gross Revenue, -11, 0)
vs.
(2) OFFSET(Gross Revenue, offset_value, 0)
Dimension is Months and 'offset_value' always equals either -12 or -11 based on a formula. Why does (1) work but (2) is a circular reference?
Sample below:
Solved! Go to Solution.
Ryan,
Feel free to use a strict lag/lead in order to avoid having to use the if statement as a solution.