Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

Excerpt

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.

Info

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

D s
snippetBasic

D code

delete row: GREATERTHAN(Errors, 10)

Output: Deletes all rows in which the value in the Errors column is greater than 10.

D s
snippetSyntax

D code

derive type:single value:GREATERTHAN(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.

D s lang notes

value1, value2

Names of the column, expressions, or literals to compare.

  • Missing values generate missing string results. 

D s
snippetusage

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


D s
snippetExamples

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

D s also
labelcomparison