Are there cases where the field being averaged is empty? And in those cases, should that count as a zero in your average?
When FileMaker summary fields or the Average function compute the mean, they ignore null values.
values of 4 ; <null> ; 5 will produce a mean of 4.5 ( [4 + 5]/2 ), instead of a mean of 3 ( [4 + 0 + 5] / 3 ).
If this is the case, put a zero in those fields if you want them treated as a zero value.
There are no null values and no zero values (at this time).
How do you need the average to be calculated?
FileMaker is calculating the average over all the records in your sorted group and over all the records in the entire found set. Each record is given equal "weight".
Might the average that you want be: ( OctoberAverage + NovemberAverage + DecemberAverage ) / 3 ??
OK, I get what is happening now and it makes sense!