Skip to main content
Skip table of contents

SUBTRACTION (-)

Basic Overview

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

YearValue
20175
201810

Node B

YearProductValue
2017A2
2018A3
2018B4

A-B =

YearValue
2017

5-2 = 5

201810-(3+4) = 3
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.