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

Issue with double counting bed types
We added new bed types to eventually move from the old "All Beds, single, double" I inputted the data into the new bed types Went to double check flow into other modules and found that they are being double counted even though I blanked the original columns out. I am not sure why it is still counting All Beds even if it is…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…