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