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 |
---|
|