Return to FileMaker.com
Average of grouped figures
Let's say I have a simple table set up like this:
CustomerID | Value
1 | 10
2 | 10
Total for Customer 1 = 40.
Total for Customer 2 = 30.
If I ask FM to do an average of value, it will return 10, based on 70/7 which is pretty correct.
However, I want it to return 40 + 30 / 2 = 35, quite different from 10.
How would I go about telling FM to average only the summed figures by customerID group?
Try using the weighted average option for your summary field.
Retrieving data ...