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.