RangeCount() returns the number of values, text and numeric, found within the specified range or expression.
Syntax:
RangeCount(first_expr {,Expression})
Return data type: integer
Arguments:
The argument expressions of this function may contain inter-record functions with a third optional parameter, which in themselves return a range of values.
| Argument | Description |
|---|---|
| first_expr | The expression or field containing the data to be measured. |
| Expression | Optional expressions or fields containing the range of data to be measured. |
Limitations:
NULL values are not counted.
Examples and results:
| Examples | Results |
|---|---|
| RangeCount (1,2,4) |
Returns 3 |
|
RangeCount (2,'xyz') |
Returns 2 |
| RangeCount (null( )) | Returns 0 |
| RangeCount (2,'xyz', null()) | Returns 2 |
Example with expression:
RangeCount (Above(Sum(MyField),1,3))
Returns the number of values within the three results of the Sum(MyField) function above the current row.
Data used in examples:
| MyField | RangeCount(Above(Sum(MyField),1,3)) |
|---|---|
|
23 |
0 |
| 63 | 1 |
| 74 | 2 |
| 89 | 3 |
| 44 | 3 |
| 54 | 3 |