A moving average is a nice way of smoothing out noisy data, giving a clearer indication of how something’s trending over time. I’ve seen the requirement a few times so here we go…
=(RunningSum([Revenue]) - RunningSum(Previous([Revenue]; 5))) / 5
Read more »