- Contents
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. |