CELLLT
Usage
Use this function to make comparison between cell values or between a cell value and constant value using "LESS 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
=CELLLT(#StorageExample.Column.METADATA; 1)
Description
Check if the cell values of the field Column in the StorageExample are less than 1
Result
true or false
Example 2
Formula
=CELLLT(#StorageExample.Date.METADATA; $CURRENTDATE)
Description
Check if the cell values of the field Date in the StorageExample are less than current date (variable)
Result
true or false
Example 3
Formula
=CELLLT(#StorageExample.Column_1.METADATA; #StorageExample.Column_2.METADATA)
Description
Check if the cell values of the field Column_1 in the StorageExample are less than Column_2 in the StorageExample
Result
true or false
Example 4
Formula
=CELLLT(#StorageExample.Column.METADATA; =FUNCTION_EXAMPLE(...))
Description
Check if the cell values of the field Column in the StorageExample are less than the result of the function
Result
true or false