Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

D toc

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.


NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Logical Operators.


D s

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 s

D code

derive type:single value:NOT(value1)

ArgumentRequired?Data TypeDescription
value1YstringThe value must be a Boolean literal, column reference, or expression that evaluates to true or false.

D s lang notes


Expression, column reference or literal that evaluates to a Boolean value.

  • Missing or mismatched values generate missing results. 

D s

Required?Data TypeExample Value
YesFunction or column reference returning a Boolean value or Boolean literalmyHeight > 2.00

D s

Example - Logical Functions

Include Page
EXAMPLE - Logical Functions
EXAMPLE - Logical Functions

D s also