Hi Andrew, This doesn't work if the total score fields have no records as opposed to records with a blank. (hope that makes sense)Can you think of a way to capture missing values and do the same as...
Hi Robert Did you make any progress? I'm looking at the same and think the first step is to calc the Centred Moving average (Roll Mean in R?)Jason