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

Filter dropdown for form action
Hi, I have a form action button that adds a L5 list item to a hierarchy. L5 does not have selective access but L4 does, but I still see all L4 list items in the dropdown when I trigger the form. How can I only view the ones I should have selective access to? L5 does not have selective access. L4 is also a selector on this…
RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…