IS_NA

Overview

Description

Returns true (1) for any values that are not available (undefined) in the input in the dimension of the input (for example when no data for a product exists). It returns false (0) for any values that exist in the input.

Use when you want to detect undefined values explicitly before they cause unexpected empty results in downstream logic.

Syntax

IS_NA('Node')

Parameters

Node: Input node, specified using the node name in single quotes (e.g. 'Profit').

Performance impact
IS_NA expands the full dimensionality of the input. This might mean you reach the maximum cube size.

Examples

Typical use

This example shows that IS_NA returns 1 only where the input is undefined and 0 where a value exists.

Input node: A

Year	Value
2025	400
2026	0
2027	850
2028

Formula: IS_NA('A')

Year	→ IS_NA Result
2025	0
2026	0
2027	0
2028	1

Related Functions

Function	When to use instead
FALSE	When you need a constant 0 for defined values instead of detecting missing ones.
TRUE	When you need a constant 1 for defined values instead of marking undefined ones.