AnsweredAssumed Answered

Averages

Question asked by john9210 on Sep 19, 2014
Latest reply on Sep 19, 2014 by philmodjunk

Title

Averages

Post

FM 12 adv. I have records with cost data. I want to get 7 day averages of costs so I can use them on a graph. I can’t figure out how to do this. For example: Say I have 100 records, I want to sort them in order and then get the average of the first 7, the second 7, the third 7, etc.

 

Outcomes