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