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