View Source

Returns true if the first argument is greater than but not 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 that contains 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.

greaterthan(Errors, 10)

Output: Returns true when the value in the Errors column is greater than 10.

greaterthan(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