DELTA_REL

AVAILABLE FROM 6.13

Description	Calculates the relative difference between consecutive values within the selected dimension.
Syntax	DELTA_REL('Node', [“Dimension”, [“FirstValueBehavior”]])
Parameter	Node: Input node, specified using the node name in single quotes (e.g. 'Profit') Dimension: The dimension along which consecutive values are compared. Optional parameter, default value: “Time” at the nodes finest level. FirstValueBehavior: How the first value per unique level combination apart from “Dimension” is handled. Optional parameter, default value: “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 growth will always be calculated on the lowest available level of the specified 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. The function compares only entries that actually exist in the input. Missing values are skipped. To calculate the growth with filled missing values use YOY_REL The 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.

Example

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).
This means for example: The relative growth from -2 to -10 is -400% as (-10 - (-2)) / abs(-2) = (-8 / 2) = -4.

Input node =

Year	Month	Product	Measure
2025	2025-11	A	1
2025	2025-11	B	2
2026	2026-04	A	20
2026	2026-05	B	-10

DELTA_REL(‘Input node’) = DELTA_REL( ‘Input node’ , "Time" , "SKIP_FIRST") =

Year	Month	Product	Measure
2026	2026-04	A	19 (= (20 - 1) / ABS(1) )
2026	2026-05	B	-6 (= (-10 - 2) / ABS(2) )

DELTA_REL(‘Input node’, "Time" , "FIRST_AS_ZERO") =

Year	Month	Product	Measure
2025	2025-11	A	0
2025	2025-11	B	0
2026	2026-04	A	19
2026	2026-05	B	-6