| Excerpt |
|---|
Returns true if the first argument is less than or equal to the second argument. Equivalent to the <= operator. |
- Each argument can be a literal Integer or Decimal number, a function returning a number, or a reference to a column containing numbers.
Since the function returns a Boolean value, it can be used as a function or a conditional.
| Info |
|---|
NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Comparison Operators. |
| D code |
|---|
keep row: LESSTHANEQUAL(myValue, maxLimit) |
Output: Keeps all rows in which the value in the myValue column is less than or equal to the value in maxLimit.
| D code |
|---|
derive type:single value:LESSTHANEQUAL(value1, value2) |
| Argument | Required? | Data Type | Description |
|---|
| value1 | Y | string | The first value. This can be a number, a function returning a number, or a column containing numbers. |
| value2 | Y | string | The second value. This can be a number, a function returning a number, or a column containing numbers. |
value1, value2
Names of the column, expressions, or literals to compare.
- Missing values generate missing string results.
| Required? | Data Type | Example Value |
|---|
| Yes | Column reference, function, or numeric or String value | myColumn |
Example - Basic Comparison Functions
| Include Page |
|---|
| EXAMPLE - Comparison Functions1 |
|---|
| EXAMPLE - Comparison Functions1 |
|---|
|
Example - Using Comparisons to Test Ranges
| Include Page |
|---|
| EXAMPLE - Comparison Functions2 |
|---|
| EXAMPLE - Comparison Functions2 |
|---|
|
