You can use logical functions in a formula to return true or false.
|
Function |
Syntax |
Description |
|---|---|---|
|
IsNotNull(obj) |
obj: User object (column) |
Returns a Boolean value that indicates whether a supplied field does not contain a null value. When a field contains a null value, the function returns false. For all other values, the function returns true. |
|
IsNull(obj) |
obj: User object (column) |
Returns a Boolean value that indicates whether the supplied field contains a null value. When a field contains a null value, the function returns true. For all other values, the function returns false. |
|
<left> and <right> |
|
Returns the logical conjunction of its Boolean inputs. This function returns false: true and false. |
|
<left> or <right> |
|
Returns the logical disjunction of its Boolean inputs. This function returns true: true or false. |
|
if<cond> then <alt1> else <alt2> |
|
Chooses between two alternatives, based on a Boolean condition. The second alternative is optional and evaluates to null when missing. |
|
<testExpr> in <candidateList> |
|
Use to determine whether a first input matches a value in a second input list. For
example:
3 in [2, 4, 6] |
|
not<bool> |
bool: A Boolean |
Use to negate a Boolean input. For
example:
not false |
|
Left |
Right |
Result of {Left} and {Right} |
|---|---|---|
|
True |
True |
true |
|
True |
False |
false |
|
False |
True |
false |
|
False |
False |
false |
| Left | Right | Result of {Left} or {Right} |
|---|---|---|
| True | True | true |
| True | False | true |
| False | True | true |
| False | False | false |