Aggregate Functions
The following aggregate functions are available:
Function | Examples | Description |
---|---|---|
Count( expression ) | Count( Fax ) or Count( * ) | Counts all of the non null items of expression. Use a "*" for counting all items of the record set. |
Sum( expression ) | Sum( LineTotal ) or Sum( Multiply( UnitPrice, Quantity ) ) | Sums all of the expression values. |
First( expression ) | First( Fax ) | Returns the first expression value of all items of the record set. |
Last( expression ) | Last( Fax ) | Returns the last expression value of all items of the record set. |
Mean( expression ) | Mean( Quantity ) | Returns the average of all of the expression values. |
Median( expression ) | Median( ProductName ) | Returns the median expression value. |
Mode( expression ) | Mode( Marks ) | Returns the least most frequent expression value. |
Max( expression ) | Max( Quantity ) | Returns the maximum expression value. |
Min( expression ) | Min( Quantity ) | Returns the minimum expression value. |
StDev( expression ) | StDev( Quantity ) | Returns the standard deviation of a numeric expression evaluated over a set. |