DELTA_REL

Description

Returns a relative growth for each level value compared to its former level value based on the order in the dimension.

Syntax

DELTA_REL('Node', [“Dimension”, [“FirstValueBehavior”]])

Parameter

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

• Dimension: The name of the dimension, the growth should be calculated for.

  • Optional parameter, defaults to “Time”.

• FirstValueBehavior: How the first value per unique level combination apart from “Dimension” is handled.

  • Optional parameter, defaults to “SKIP_FIRST”.

  • Valid values: “SKIP_FIRST” and “FIRST_AS_ZERO”.

    • SKIP_FIRST: the first level combination per group will not be present in the result.

    • FIRST_AS_ZERO: the value of the first level combination will be set to zero.

Limitations

• The relative growth will always be calculated on the lowest available level of “Dimension”.

• If the “former value” is zero, the calculation cannot be performed as a division by zero is not possible. The level combination will therefore not be in the result.

• Important: This function ensures that the links from the levels of the specified dimension match those in the dimension management.

  • Do not use this function if you want the node to have different level links as the dimensions.

Remarks

In contrast to YOY_REL and related relative functions, the growth will be calculated by using the absolute former value as relative base: (currentValue - formerValue) / absolute(formerValue).

• Example: The relative growth from -2 to -10 is -400% as (-10 - (-2)) / abs(-2) = (-8 / 2) = -4.

2025

2025-11

A

1

2025

2025-11

B

2

2026

2026-04

A

20

2026

2026-05

B

-10

2026

2026-04

A

19 (= (20 - 1) / ABS(1) )

2026

2026-05

B

-6 (= (-10 - 2) / ABS(2) )

2025

2025-11

A

0

2025

2025-11

B

0

2026

2026-04

A

19

2026

2026-05

B

-6