Get Average of two month on same line item when is Budget

Options
Ganza
Ganza Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi ,

 

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

Tagged:

Comments

  • Ganza
    Ganza Member, ALL USERS, Certified Model Builder Posts: 5 Occasional Contributor

    Hi @M.Kierepka ,

     

    Thanks so much, you are right, I was referencing the current month which is incorrect.

    My bad 

Categories