Rolling 3 month avg and previous 3 month avg

[Anonymous]

Hi All,

I am trying to get a rolling average for the three months prior to the current three month average. (Displaying this in a text box)

Here is the formula that I am using for the current three month rolling average.

Thank you for the help in advance!

[sunny_talwar]

Can you paste your expression as a text so that we can offer modification?

[Anonymous]

Sure, Thank you.

=round(sum(if(MSPClinStartDateClean>AddMonths(today(),-3), [MSPClin Overall facility experience]))/count(distinct(if(MSPClinStartDateClean>AddMonths(today(),-3), [MSPClinResponseID]))),0.01)

[sinanozdemir · Accepted solution]

I guess you can try:

MSPClinStartDateClean>=AddMonths(today(), -6) And MSPClinStartDateClean<=AddMonths(today(), -3)

[Anonymous]

Thank you for the help Sinan, that did the trick.

Cheers

[sinanozdemir]

You are welcome.