Documentation Index

Fetch the complete documentation index at: https://kb.pigment.com/llms.txt

Use this file to discover all available pages before exploring further.

Scheduled maintenance: On Wednesday, July 22, we'll perform essential maintenance on our documentation site. While there shouldn't be any disruption, you may notice temporary changes as we make improvements.

NOT function

  • Updated on Aug 22, 2025
  • 1 minute(s) read
Prev Next

Description

Inverts the result of a given logical expression.

Syntax

NOT logical

Return type

Boolean (TRUE or FALSE)

Examples

Case

Results

Return Type

NOT TRUE

FALSE

boolean

NOT country.hasSeaBoarder

TRUE when the boolean property hasSeaBoarder of a country list is FALSE

boolean

NOT Month.Quarter.'Quarter of Year' = "Q1"

TRUE for all non Q1 months

boolean

Excel equivalent: NOT(logical)

See also: AND, OR, IN

Related articles
  • FALSE function
    Functions and Dimension modifiers > Logical Functions
  • OR function
    Functions and Dimension modifiers > Logical Functions
  • IF function
    Functions and Dimension modifiers > Logical Functions