Returns true if the first argument is greater than or equal to the second argument. Equivalent to the >= operator.

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: GREATERTHANEQUAL(myValue, minLimit)

Output: Keeps all rows in which the value in the myValue column is greater than or equal to the value in minLimit.

derive type:single value:GREATERTHANEQUAL(value1, value2)

ArgumentRequired?Data TypeDescription
value1YstringThe first value. This can be a number, a function returning a number, or a column containing numbers.
value2YstringThe 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.

Required?Data TypeExample Value
YesColumn reference, function, or numeric or String valuemyColumn


Example - Basic Comparison Functions

Example - Using Comparisons to Test Ranges