FALSE

In Logical functions

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

Use this function when you need a node of all zeros that matches the dimensionality of an existing node, for example as a baseline or reset value: FALSE('Revenue').

Parameters

NodeNode referenceRequired

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

Output shape

Dimensionality

Same as input.

Values

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

Row count

Same as input. Only defined rows produce output.

Watch out

Examples

Returns 0 for all defined rows

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

Input node: 'Revenue'

Formula: FALSE('Revenue')

FALSE applied to a combined expression

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

Undefined values are preserved

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

Input node: 'A'

Formula: FALSE('A')

See also

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