NOT
Category: Logical functions
Overview
| Description | Inverts the input values with the logical NOT operation. If the input is true (non-zero), false (0) is returned, and true (1) otherwise. Use when you want to invert an existing logical condition so true becomes false and false becomes true. |
| Syntax | NOT('Node') |
| Parameters | Node: Input node, specified using the node name in single quotes (e.g. 'Profit'). |
Examples
Typical use
This example shows that NOT turns non-zero values into 0 and turns 0 into 1.
Input node: A
| Year | Value |
|---|---|
| 2025 | 400 |
| 2026 | 0 |
| 2027 | 850 |
| 2028 | 500 |
Formula: NOT('A')
| Year | → NOT Result |
|---|---|
| 2025 | 0 |
| 2026 | 1 |
| 2027 | 0 |
| 2028 | 0 |
Related Functions
| Function | When to use instead |
|---|---|
| TRUE | When you need a constant true condition instead of inverting an existing logical result. |
| IS_NA | When you want to detect undefined values instead of inverting true and false results. |