FALSE

Overview

Description

Returns false (0) for every defined value in the input.

Use this when you need a node of all zeros that matches the dimensionality of an existing node, for example as a baseline or reset value.

Syntax

FALSE('Node')

Parameters

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

Function alternative
If you need a 0 for each undefined row, look at the IS_NA function, and invert its result with FALSE.

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

Input node: Revenue

Formula: FALSE('Revenue')

When FALSE is applied to a sum of two nodes, it returns 0 for every row where the combined expression produces a defined value.

Input node: Products

Formula: FALSE('Revenue'+'Products')

FALSE only produces 0 for defined values. Rows where the input is undefined remain undefined in the result.

Input node: A

Formula: FALSE('A')

Function	When to use instead
TRUE	When you need 1 (true) for every defined value instead of 0.
IS_NA	When you need to detect undefined values (returns 1 where undefined, 0 where defined).