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