FALSE
Basic 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. |
Signature | FALSE(Node) |
Parameters |
|
Example
DecimalNode =
Year | Revenue |
2018 | -24.5 |
2019 | 95 |
2020 | 110 |
Output FALSE('DecimalNode') =
Year | Revenue |
2018 | 0 |
2019 | 0 |
2020 | 0 |
Products =
| Year | Product | Revenue |
| 2018 | A | 67 |
| 2019 | B | 85 |
| 2020 | A | 954 |
| 2020 | B | -54 |
Output FALSE('DecimalNode'+'Products') =
| Year | Revenue |
| 2018 | 0 |
| 2019 | 0 |
| 2020 | 0 |
A=
| Year | Revenue |
| 2018 | 95 |
| 2019 | |
| 2020 | 236 |
Output FALSE('A') =
| Year | Revenue |
| 2018 | 0 |
| 2019 | |
| 2020 | 0 |