IS_NA
Basic Overview
Description | Returns true (1) for any values that are not available (undefined) in the input in the dimension of the input (E.g. when no data for a product exists). And returns false (0) for any values that exist in the input. Note: Returns a fully expanded cube with the dimensionality of the input. |
|---|---|
Syntax | IS_NA(Node) |
Parameter | Node: Input node, specified using the node name in single quotes (e.g. 'Profit') |
Caution
This expands the full dimensionality of the input cube. This might mean you reach the maximum cube size.
Example
Input A =
Year | Value |
|---|---|
2019 | 400 |
2020 | 0 |
2021 | 850 |
2022 |
Output IS_NA('A') =
Year | Value |
|---|---|
2019 | 0 |
2020 | 0 |
2021 | 0 |
2022 | 1 |