Name | Syntax | Return | Description | Status |
|---|---|---|---|---|
| Decimal number (scalar) | Adds all numbers in a column. Operates in filter context and ignores blank values and text | Done | |
| Decimal number (scalar) | Returns the average (arithmetic mean) of all the numbers in a column | Done | |
| Scalar value | Returns the smallest value in a column | Done | |
| Scalar value | Returns the largest value in a column | Done | |
| Decimal number (scalar) | Returns the product of the numbers in a column. | Done | |
| Decimal number (scalar) | Returns the average (arithmetic mean) of the values in a column. | Done | |
| Scalar value | Returns the largest value in a column | Done | |
| Scalar value | Returns the smallest value in a column, including any logical values and numbers represented as text. | Done | |
| Whole number (integer) | Counts the number of rows in the specified column that contain non-blank values | Done | |
| Whole number (integer) | Counts the number of rows in the specified column that contain non-blank values. Supports Boolean values. | Done | |
| Whole number (integer) | Counts the number of blank cells in a column. | Done | |
| Whole number (integer) | Counts the number of rows in the specified table, or in a table defined by an expression. | Done | |
| Whole number (integer) | Counts the number of distinct values in a column | Done | |
| Whole number (integer) | Counts the number of distinct values in a column. | Done | |
| Whole number (integer) | Returns an estimated count of unique values in a column. | Done | |
| Decimal number (scalar) | Returns the sum of an expression evaluated for each row in a table | Done | |
| Decimal number (scalar) | Calculates the average (arithmetic mean) of a set of expressions evaluated over a table. | Done | |
| Whole number (integer) | Counts the number of rows that contain a number or an expression that evaluates to a number, when evaluating an expression over a table. | Done | |
| Whole number (integer) | Counts non-blank results when evaluating the result of an expression over a table. | Done | |
| Scalar value | Evaluates an expression for each row of a table and returns the largest numeric value. | Done | |
| Scalar value | Returns the smallest numeric value that results from evaluating an expression for each row of a table. | Done | |
| Decimal number (scalar) | Returns the product of an expression evaluated for each row in a table. | Done |