ADDITION (+)

In Arithmetic operators

The ADDITION operator adds two inputs after aligning them to their common dimensions. In other words, addition uses the intersection of the shared dimensions.

The result keeps the coarser level in each shared dimension. Dimensions that exist on only one side are aggregated away.

Use this operator to combine values from two or more nodes: 'Revenue BU1' + 'Revenue BU2'.

Parameters

Node1Node referenceRequired

First input node, specified in single quotes (e.g.'Revenue BU1')

Node2Node referenceRequired

Second input node, specified in single quotes (e.g.'Revenue BU2')

Output shape

Dimensionality

Both inputs are aggregated to their common dimensions (the intersection of the shared dimensions). Per shared dimension, the coarser level is used. Dimensions that exist on only one side are aggregated away.

Level values

Non-matching level values are preserved in the result.

Row count

Equal or reduced, depending on how much aggregation is required before adding.

Watch out

Examples

Adding nodes with different dimensionality

This example shows how addition aggregates Node B to the common dimensions before adding it to Node A.

Input node: 'A'

Input node: 'B'

Formula: 'A'+'B'

Adding nodes with different level values

When level values do not overlap, addition preserves both values in the result.

Input node: 'A'

Input node: 'B'

Formula: 'A' + 'B'

Adding a constant to a node

When one operand is a constant, the node is aggregated first and the constant is then added to the total.

Input node: 'Sales'

Formula: 'Sales' + 100

See also

UNION

When both nodes have the same levels and you want to enforce that constraint (stricter version of ADDITION).

ADDEACH

When you need to add a value to each individual entry before aggregation, rather than combining two nodes.

SUBTRACTION (-)

When you need tosubtract nodes instead of adding them. Uses the same roll-up logic.