View Source

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.

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Comparison Operators.

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.

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`

value1, value2

Example - Basic Comparison Functions

Example - Using Comparisons to Test Ranges