Skip to main content
Skip table of contents

DELTA_ABS

Available from Valsight Version 6.13 (July 2025)

Description

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

Syntax

DELTA_ABS('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”, “FIRST_AS_ZERO” and “FIRST_VALUE”.

      • 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.

      • FIRST_VALUE: the value of the first level combination stays as it is.

Limitations

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

  • 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.

Example

Input: Profit =

Year

Month

Product

Measure

2025

2025-11

A

1

2025

2025-11

B

2

2026

2026-04

A

20

2026

2026-05

B

-10

Output: DELTA_ABS( ‘Profit’ ) = DELTA_ABS( ‘Profit’ , "Time" , "SKIP_FIRST") =

Year

Month

Product

Measure

2026

2026-04

A

19 (= 20 - 1)

2026

2026-05

B

-12 (= -10 - 2)

Output: DELTA_ABS( ‘Profit’ , "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

-12

Output: DELTA_ABS( ‘Profit’ , "Time" , "FIRST_VALUE") =

Year

Month

Product

Measure

2025

2025-11

A

1

2025

2025-11

B

2

2026

2026-04

A

19

2026

2026-05

B

-12

JavaScript errors detected

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

If this problem persists, please contact our support.