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


FAQs

Frequently asked questions can be found here

Contact 

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

*Except Public holidays in Berlin, Germany.

JavaScript errors detected

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

If this problem persists, please contact our support.