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 |
|
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 |