ADDITION (+)

Overview

The ADDITION operator adds up nodes by rolling them up to the same set of levels (intersect). The result has the coarser level of each shared dimension. When both nodes share the same dimensions and levels, matching values are added row by row.

Use this operator to combine values from two or more nodes.

Syntax

'Node1' + 'Node2'

Example usage: 'Revenue BU1' + 'Revenue BU2'

Parameters

Parameter	Description	Type	Required
Node1	First summand node, specified using the node name in single quotes (e.g.`'Revenue BU1'`)	Node reference	Yes
Node2	Second summand node, specified using the node name in single quotes (e.g.`'Revenue BU2'`)	Node reference	Yes

Output Shape

Aspect	Behavior
Dimensionality	Both inputs are rolled up to their common dimensions (intersection). 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 (see Example 2).
Row count	Equal or reduced (due to roll-up when inputs differ in dimensionality).

Watch Out

Addition rolls up to common dimensions (intersection). This is different from multiplication, which keeps all dimensions from both sides (union).
When adding a constant (e.g. 'Revenue' + 100), the node is aggregated first and then the constant is added to the total. To add a value to each individual entry before aggregation, use ADDEACH.
Both sides must have the same unit, or one side must be a scalar value.

Examples

Adding nodes with different dimensionality

This example shows how ADDITION rolls up Node B (which has a Product dimension) to match Node A's coarser level before adding.

Input node: A

Year	Value
2025	5
2026	10

Input node: B

Year	Product	Value
2025	A	2
2026	A	3
2026	B	4

Formula: 'A'+'B'

Year	→ ADDITION Result
2025	5+2 = 7
2026	10+3+4 = 17

Adding nodes with different level values

This example shows that when nodes have different level values, ADDITION preserves both values in the result.

Input node: A

Year	Value
2025	5

Input node: B

Year	Value
2026	10

Formula: 'A'+'B'

Year	→ ADDITION Result
2025	5
2026	10

Adding a constant to a node

When one operand is a constant (a number without dimensions), the node is aggregated first, then the constant is added to the total. To add a value to each entry individually, use ADDEACH instead.

Input node: Sales

Year	Product	Value
2025	A	30
2025	B	20

Formula: 'Sales' + 100

Year	-> ADDITION Result
2025	30 + 20 + 100 =150

Related Functions

Function	When to use instead
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 to subtract nodes instead of adding them. Uses the same roll-up logic.