| Excerpt |
|---|
Returns true if the argument evaluates to false, and vice-versa. Equivalent to the ! operator. |
- The argument can be a literal Boolean, a function returning a Boolean, or a reference to a column containing Boolean values.
Since the function returns a Boolean value, it can be used as a function or a conditional.
| Info |
|---|
NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Logical Operators. |
| D code |
|---|
derive type:single value: NOT(customerHappiness > 70) as:'contactCustomer' |
Output: If the value in the customerHappiness column is not greater than 70 then the value in the new contactCustomer column is true. Otherwise, the value is false.
| D code |
|---|
derive type:single value:NOT(value1) |
| Argument | Required? | Data Type | Description |
|---|
| value1 | Y | string | The value must be a Boolean literal, column reference, or expression that evaluates to true or false. |
value1
Expression, column reference or literal that evaluates to a Boolean value.
- Missing or mismatched values generate missing results.
| Required? | Data Type | Example Value |
|---|
| Yes | Function or column reference returning a Boolean value or Boolean literal | myHeight > 2.00 |
Example - Logical Functions
| Include Page |
|---|
| EXAMPLE - Logical Functions |
|---|
| EXAMPLE - Logical Functions |
|---|
|
