ADDITION (+)
Category: Arithmetic operators
Overview
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.
Syntax
'Node1' + 'Node2'
Example usage: 'Revenue BU1' + 'Revenue BU2'
Parameters
| Parameter | Description | Type | Required |
|---|---|---|---|
| Node1 | First input node, specified in single quotes (e.g. 'Revenue BU1') | Node reference | Yes |
| Node2 | Second input node, specified in single quotes (e.g. 'Revenue BU2') | Node reference | Yes |
Output Shape
| Aspect | Behavior |
|---|---|
| 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
- Addition uses the common dimensions (intersection), not the combined dimension set. This is different from multiplication and division.
- When adding a constant such as
'Revenue' + 100, the node is aggregated first and the constant is then added to the total. - To add a value to each entry before aggregation, use ADDEACH instead.
- Both sides must have the same unit, unless one side is a scalar value.
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
| 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
When level values do not overlap, 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, the node is aggregated first and the constant is then added to the total.
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. |