YOY_ABS

Description

Returns the absolute growth for each year compared to the previous year (year-over-year).

Syntax YOY_ABS(Node <, MissingValueBehaviour>)
Parameter
  • Node: Input node, specified using the node name in single quotes (e.g. 'Profit')
  • MissingValueBehaviour:
    • how the function should treat missing values
    • possible value are: IGNORE_MISSING (default) and MISSING_AS_ZERO
    • available since 3.4.0
Example

Input Profit =

Year

Value

2019 200
2020 300
2021 450
2022 500
2024 100



Output 
YOY_ABS('Profit') =  YOY_ABS('Profit', "IGNORE_MISSING")

Year

Value

2020 100
2021 150
2022 50



Output YOY_ABS('Profit', "MISSING_AS_ZERO")

Year Value
2019 200
2020 100
2021 150
2022 50
2023 -500
2024 100
2025 -100
Beschreibung

Ermittelt das absolute Wachstum jedes Quartals verglichen zum Vorjahr (year-over-year).

Syntax YOY_ABS(Node)
Parameter
  • Node: Input Knoten, wird mit Knotennamen umgeben von Hochkommata angesprochen (z.B. 'Profit')
Beispiel

Input Profit =

Jahr

Wert

2019

200

2020

300

2021

450

2022 500



Output 
YOY_ABS('Profit') =

Jahr

Wert

2020

100

2021

150

2022

50

Was this helpful?

Yes | Somewhat | No