nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Average of the previous 3 months data

Hello,

I have a question,

If i want to pull the average of the previous 3 months, how can i do it?

Thanks

Tags

Modeling

Accepted answers

All comments

Try using MOVINGSM function

Formula may look like

MOVINGSUM(Line item,-2,0,AVERAGE)

Misbah

Quick Links

Can you help?

Unanswered questions

No updates on Anaplan XL Reporting formula reference page since April 2026?
The Anaplan XL Reporting formula reference page has not been updated since April 2026. It's missing any reference to the new XL3LookupAsync formula. Can we please have this page updated with all the latest features from XL?
MFP - Unable to View the LRP Plan
Hello All, The modules in the MFP model (DAT010 - Retail Based Historical Actuals, DAT020, DAT030, DAT040, DAT050, and DAT060) are already available, and the data for the different plans has been loaded. However, when I open Page 5000 - Seed Long Range LRP and select Seed Selection = LY, the following metrics are not being…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…