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.


FAQs

Frequently asked questions can be found 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.