TRUE

Category: Logical functions

Overview

Description

Returns true (1) for every defined value in the input.

Use when you need a constant true flag across all defined intersections of an input node.

Syntax

TRUE('Node')

Parameters

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

Function alternative
TRUE only returns 1 for defined rows in the input. If you need to flag undefined rows instead, use IS_NA.

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

Input node: Revenue

Formula: TRUE('Revenue')

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')

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

Input node: A

Formula: TRUE('A')

Function	When to use instead
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.