DIVISION (/)

DIVISION (/)

Description

Divides nodes by performing a join along the shared levels of the nodes (dimension union). The result has all the finest levels that are present in either of the nodes.

Signature

Node1 / Node2

Parameters

  • Node1: Dividend node, specified using the node name in single quotes (e.g. 'Profit')
  • Node2: Divisor node, specified using the node name in single quotes (e.g. 'Profit')

Example with all Shared Dimensions

Node1 = 

Year Measure
2018 6
2019 4

Node2 = 

Year Measure
2018 3
2019 1

Node1 / Node2 =

Year Measure
2018 6 / 3 = 2
2019 4 / 1 = 4

Example with some Shared Dimensions

Node1 = 

Year Product Measure
2018 A 4
2018 B 0
2019 A 4
2019 B 16


Node2 = 

Year Measure
2018 2
2019 4

Node1 / Node2 = 

Year Product Measure
2018 A 4 / 2 = 2
2018 B 0 / 4 = 0
2019 A 4 / 4 = 1
2019 B 16 / 4 = 4

Example without Shared Dimensions

Node1 = 

Year Measure
2018 4
2019 8

Node2 = 

Measure
2

Node1 / Node2 =

Year Measure
2018 4 / 2 = 2
2019 8 / 2 = 4

Was this helpful?

Yes | Somewhat | No