CELLGT
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 | CLIENT | COMPARISON | .METADATA |
Syntax
1 | |
Arguments
Value_1
any cell value (#Storage_Name.Field_Name.METADATA or .METADATA.ORIGINAL), constant, System Variables or function-returned value
Value_2
any cell value (#Storage_Name.Field_Name.METADATA or .METADATA.ORIGINAL), 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, only if their argument statement are not value-parameterized (.VALUE) on the cells of the Client rendered records
Return Value
Boolean (true or false)
Examples
Example 1
Formula
=CELLGT(#StorageExample.Column.METADATA; 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
=CELLGT(#StorageExample.Date.METADATA; $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
=CELLGT(#StorageExample.Column_1.METADATA; #StorageExample.Column_2.METADATA)
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
=CELLGT(#StorageExample.Column.METADATA; =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