Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.