Aggregate Functions

The following table describes the functions that are available when aggregating data. The functions available for an item are based on the item's data type.

Function	Description
Count	Counts the number of records for the grouping.
Sum	Totals the values within the grouping.
Average	Averages the values within the grouping.
Maximum	Calculates the highest value within the grouping.
Minimum	Calculates the lowest value within the grouping.
Standard Deviation	Averages the difference from the mean value of the entire set of accounts included.
Population Standard Deviation	Averages the difference from the mean value within the grouping.
Variance	Squares the standard deviation.
Population Variance	Squares the standard deviation within the grouping.
Eliminate Duplicates	Changes the equation to add the "distinct" clause. You can use this function with any aggregate after the initial selection.
Remove Aggregate	Deletes the aggregate function and returns the column to its literal value.