Get Average of two month on same line item when is Budget
I want just calculate the moving average for the last two months, however once use the following formula IF ISACTUALVERSION() THEN Revenue actual ELSE movingsum(Average Revenue,-2,0, AVERAGE)
Then circular reference error shows up. Could guys give me hand on how can solve these issues?
I am looking forward to your response