Min() returns the lowest numeric values found within the expression or field.
Syntax:
RangeMin(first_expr {,Expression})
Return data type: numeric
Arguments:
| 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:
If no numeric value is found, NULL is returned.
Examples and results:
| Examples | Results |
|---|---|
|
RangeMin (1,2,4) |
Returns 1 |
| RangeMin (1,'xyz') |
Returns 1 |
| RangeMin (null( ), 'abc') |
Returns NULL |
Example with expression:
RangeMin (Above(Sum(MyField),0,3))
Returns the lowest of the three results of the Sum(MyField) function evaluated on the current row and the two rows above the current row.
| MyField | RangeMin(Above(Sum(MyField),0,3)) |
|---|---|
| 10 |
10 |
| 2 | 2 |
| 8 | 2 |
| 18 | 2 |
| 5 | 5 |
| 9 | 5 |
Data used in examples:
RangeTab:
LOAD * INLINE [
MyField
10
2
8
18
5
9
] (delimiter is '|');
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!