TRUE

Category: Logical functions

Overview

The TRUE function returns 1 for every defined value in the input node. Undefined intersections remain undefined in the result.

Use this function when you need a constant true flag across all defined intersections of an input node, for example as a condition in IF or to create a binary helper table.

Syntax

TRUE('Node')

Example usage: TRUE('Revenue')

Parameters

Output Shape

Watch Out

• TRUE only covers defined rows. It does not create values where the input is undefined. If you need to flag undefined rows, use IS_NA instead.
• The input value itself does not matter. TRUE returns 1 regardless of whether the value is positive, negative, or zero. Only whether the value is defined matters.
• TRUE accepts expressions as input (e.g. TRUE('A' + 'B')). The result reflects the dimensionality and defined intersections of the combined expression.

Examples

Returns 1 for all defined rows

This example shows TRUE returning 1 for every row that has a defined value in the input node.

Input node: Revenue

Formula: TRUE('Revenue')

TRUE applied to a combined expression

This example shows TRUE applied to a sum of nodes. It returns 1 for each year where the combined expression produces a defined value.

Input node: Additional Revenue

Formula: TRUE('Revenue'+'Additional Revenue')

The addition rolls up both nodes to their common dimensions (Year only), and TRUE returns 1 for each defined year.

Undefined values remain undefined

TRUE only produces 1 for defined values. Rows where the input is undefined remain undefined in the result.

Input node: A

Formula: TRUE('A')

Year 2026 has no defined value, so it does not appear in the result.

Related Functions