Rolling average

[hansdevr]

Hi and good morning everyone!

I have a table which shows average project throughput time in days per end of month.

What I would want, is to calculate a "rolling average", but with a twist..

Month 1 should show 38.4, month 2 should show the average of sum of months 1 and 2, and so on.

In the new year, this should be reset and start over again with just the average of month 1.

What would be the best way of achieving this? Through set analysis? Load script?

Any help would be greatly appreciated!

[Anil_Babu_Samineni]

Sure, Please share Excel file

[sunny_talwar · Accepted solution]

Try this

Aggr(RangeAvg(Above(Throughput time in days expression here, 0, RowNo())), Year, Month)

[mdmukramali]

Dear @hansdevr

have you checked my attached application?

[hansdevr]

See attached...

[sunny_talwar]

Did you give this a shot?

Aggr(RangeAvg(Above(Throughput time in days expression here, 0, RowNo())), Year, Month)

[hansdevr]

I am sorry had to attend a meeting... Will check ASAP

[hansdevr]

Thanks Sunny, that did the trick!

[hansdevr]

Thanks everyone for thinking with me to solve this!! Thanks again!