Skip to main content
Skip table of contents

RATIO

Basic Overview

Description

Divides the first node by the second node, while only retaining joint Dimensions.

Syntax

RATIO(Node1, Node2)

Parameter

  • Node: Input node, specified using the node name in single quotes (e.g. 'Profit')

  • Dividend (Node1): This Node is being divided by the Divisor

  • Divisor (Node2): This Node divides the Dividend

  • The RATIO-node may not be further used in other nodes. It needs to be an "end-node".

Advantages

  • Only shared dimensions are kept

  • With the RATIO formula, the data can be weighted automatically (based on another shared dimension)

  • In the workspace, the RATIO formula automatically selects the correct calculation for the respective aggregation

    • Example: The RATIO node is calculated on months, but the values in the workspace are correctly retrievable on months, quarters and years.

Example

Input A =


Year

Value

2019

15

2020

28

2021

126


Input B =


Year

Value

2019

2

2020

2

2021

3


Output RATIO('A', 'B') =


Year

Value

2019

7.5

2020

14

2021

42



JavaScript errors detected

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

If this problem persists, please contact our support.