AnsweredAssumed Answered

moving average

Question asked by jared67 on Jan 4, 2011
Latest reply on Jan 6, 2011 by Sorbsbuster


moving average


I’m trying to generate a moving average on day’s worth of material as records.

If I have a simple set-up.

day1    2 miles
day2    4 miles
day3    1.4 miles
day4    2 miles

On day5 (for example) I’d like to calculate the moving 3-day (prior) average. I have no clue how to exactly do this. I have ideas, but they seem tougher to pull off in FM versus Excel. Are there shortcuts or functions I missed?