GT
Usage
Use this function to make comparison between cell values or between a cell value and constant value using "GREATER THAN" expression
| Category | Function | Type | Where to use | Argument statement |
|---|---|---|---|---|
| FUNCTION | SERVER ROW | COMPARISON | .VALUE |
Syntax
1 | |
Arguments
Value_1
any cell value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant, System Variables or function-returned value
Value_2
any cell value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant, System Variables or function-returned value
Note
Both arguments must have the same data type and you can use values returned by other functions
Return Value
Boolean (true or false)
Examples
Example 1
Formula
=GT(#StorageExample.Column.VALUE; 1)
Description
Check if the cell values of the field Column in the StorageExample are greater than 1
Result
true or false
Example 2
Formula
=GT(#StorageExample.Date.VALUE; $CURRENTDATE)
Description
Check if the cell values of the field Date in the StorageExample are greater than current date (variable)
Result
true or false
Example 3
Formula
=GT(#StorageExample.Column_1.VALUE; #StorageExample.Column_2.VALUE)
Description
Check if the cell values of the field Column_1 in the StorageExample are greater than Column_2 in the StorageExample
Result
true or false
Example 4
Formula
=GT(#StorageExample.Column.VALUE; =FUNCTION_EXAMPLE(...))
Description
Check if the cell values of the field Column in the StorageExample are greater than the result of the function
Result
true or false