Sep 29, 2014
Thanks for the support I had from you and I have had these formulas which help me a lot to understand the trend of data better, however the missing cell values stop the formula computing. Do you have any ideas to eliminate this problem?
If( Row() == 1,
(:CUMULATIVE SCORE[Row() - 1] * (Row() - 1) + :SCORE) / Row()
ROLLING AVERAGE (for last seven days)
If( Row() > 6,
Mean( :SCORE[Index( Row() - 6, Row() )] )
Jun 18, 2012
Take a look at this post on efficient moving average algorithm. I use the formula a lot.
Re: Efficient moving average algorithm