ADDITION (+)

Basic 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.
Signature	Node1 + Node2
Parameters	Node1: First summand node, specified using the node name in single quotes (e.g. 'Profit') Node2: Second summand node, specified using the node name in single quotes (e.g. 'Profit')

Example

A =

Year	Value
2017	5
2018	10

B =

Year	Product	Value
2017	A	2
2018	A	3
2018	B	4

A+B =

Year	Value
2017	5+2 = 7
2018	10+3+4 = 17

Example with Shared Dimensions and Levels but different Level Values

A =

Year	Value
2017	5

B =

Year	Value
2018	10

A+B =

Year	Value
2017	5
2018	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.

Contact

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

_{*Except Public holidays in Berlin, Germany.}