FALSE
Overview
Please note that FALSE will only return a 0 for every defined row in the input. If you need a 0 for each undefined row, look at the IS_NA function, and invert its result with FALSE.
Description | Returns false (0) for every defined value in the input. |
Syntax |
|
Parameters | Node: Input node, specified using the node name in single quotes (e.g. |
Examples
Input node: Revenue
Year | Value |
2025 | -24.5 |
2026 | 95 |
2027 | 110 |
Output FALSE('Revenue')
Year | → FALSE Result |
2025 | 0 |
2026 | 0 |
2027 | 0 |
Input node: Products
Year | Product | Value |
2025 | A | 67 |
2026 | B | 85 |
2027 | A | 954 |
2027 | B | -54 |
Output FALSE('Revenue'+'Products') =
Year | → FALSE Result |
2025 | 0 |
2026 | 0 |
2027 | 0 |
Input node: A
Year | Value |
2025 | 95 |
2026 | |
2027 | 236 |
Output FALSE('A')
Year | → FALSE Result |
2025 | 0 |
2026 | |
2027 | 0 |