RangeCount - script and chart function
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 |
Learn more
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!