ADDITION (+)

ADDITION (+)

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

Was this helpful?

Yes | Somewhat | No