| 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 code |
|---|
delete row: GREATERTHAN(Errors, 10) |
Output: Deletes all rows in which the value in the Errors column is greater than 10.
| D code |
|---|
derive type:single value: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 |
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 |
|---|
|
