ADDITION (+)

Overview

Description	Adds up nodes by rolling them up to the same set of levels (intersect). The result has the coarser level of each shared dimension of the input nodes.
Syntax	`'Node1' + 'Node2'`
Parameters	Node1: First summand node, specified using the node name in single quotes (e.g. `'Revenue BU1'`) Node2: Second summand node, specified using the node name in single quotes (e.g. `'Revenue BU2'`)

Examples

Node: A

Year	Value
2025	5
2026	10

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

Example with Shared Dimensions and Levels but different Level Values

Node: A

Year	Value
2025	5

Node: B

Year	Value
2026	10

Formula

'A'+'B' =

Year	→ ADDITION Result
2025	5
2026	10

UNION node formula

For a more restricted version of the ADDITION formula, please use the UNION function.

Whereas the ADDITION formula allows nodes with different levels to be combined, the UNION formula is restricted to only combine nodes that contain the same levels.

This formula can also be used as a validation method as only nodes with the same levels can be 'united'.

For more information, click here.