Avg
The Avg function calculates the average value of a column of numbers. The average value of a column is equal to the sum of the values divided by the number of values.
Syntax
Avg([column])
- column (required) - the column of numbers that is evaluated for the average.
Example
Avg([Profit])
- Calculate the average profit in a group.
Avg([Population 2010] - [Population 2000])
- Calculate the average change in population in a group.