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

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

Support_137953.PNG

Accepted answers

M.Kierepka

Hi @Ganza,

You should update your MOVINGSUM part to movingsum(Average Revenue,-2,-1, AVERAGE). Please, notice that the only change is from 0 to -1 in the third argument (so average of current_month-2 and current_month-1) - you can't reference the same month of the same line item in MOVINGSUM formula, as you would need to know the value before you calculate it, causing circular reference.
Please keep in mind that this will cause further months to be calculated as average of averages, which may be incorrect from business standpoint.

Ganza

Hi @M.Kierepka ,

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

My bad

All comments

M.Kierepka

Ganza

Hi @M.Kierepka ,

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

My bad

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…