Formulae: Calculating moving averages?

joemako · May 2, 2012 7:31PM

If I want to get a moving average for ten records in a formula field added into a Field Organiser block in DataManager, is there an easier way than something like:

SUBSET_SUM([Value],SUBSET2([Row],[Row],([Row]-10),[Row], ">", "<="))/10...where in the previous operation, the function CURRENTROW() populates the [Row] field?

steve · May 3, 2012 1:37AM

You should be able to do this (add both formula fields) in a single operation.

This solution looks good; you can write it more readably using:

INTERSECTION(SUBSET([Row], [Row]-10, ">"), SUBSET([Row], [Row], "<=") )...but I wouldn't change it...

Welcome!

Categories

Ideas Parade

Tagged