YOY_ABS

Basic Overview

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

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

Difference between YOY_REL(), YOY_ABS(), and RATIO(PY())

When aiming to compare values across time periods, there are three very similar ways to do so. At the first look, they appear to function in the same way; they do however possess small but important differences that can lead to vastly different results. For more information please refer to Difference between YOY_REL(), YOY_ABS(), and RATIO(PY()) .