SUBTRACTION (-)

SUBTRACTION (-)

Description

Subtracts 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: Minuend node, specified using the node name in single quotes (e.g. 'Revenue')
  • Node2: Subtrahend node, specified using the node name in single quotes (e.g. 'OPEX')

Examples

The Subtraction works exactly as the opposite operation to the addition. 

We recommend to add all costs as negative values, hence you will not need the subtraction often.

Node A

Year Value
2017 5
2018 10

Node B

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

A-B =

Year Value
2017

5-2 = 5

2018 10-(3+4) = 3

Was this helpful?

Yes | Somewhat | No