TRUE

In Logical functions

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: TRUE('Revenue').

Parameters

NodeNode referenceRequired

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

Output shape

Dimensionality

Same as input.

Values

1 for every defined intersection. Undefined intersections remain undefined (N/A).

Row count

Same as input. Only defined rows produce output.

Watch out

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.

See also

FALSE

When you need 0 for every defined value instead of 1.

IS_NA

When you need to detect undefined values rather than marking already defined intersections as true.