Aggregate Enumeration
Enumeration members
Avg
Returns the average value of the numeric values in the group.
Cnt
Returns the count of non-null values in the group.
CntAll
Returns the count of all values in the group (including nulls).
First
Returns the first non-null value in the group.
Last
Returns the last non-null value in the group.
Max
Returns the maximum value in the group.
Min
Returns the minimum value in the group.
None
No aggregate.
Rng
Returns the difference between the maximum and minimum numeric values in the group.
Std
Returns the sample standard deviation of the numeric values in the group (uses the formula based on n-1).
StdPop
Returns the population standard deviation of the values in the group (uses the formula based on n).
Sum
Returns the sum of the numeric values in the group.
Var
Returns the sample variance of the numeric values in the group (uses the formula based on n-1).
VarPop
Returns the population variance of the values in the group (uses the formula based on n).
Specifies the type of aggregate to calculate over a group of values.