YOY_REL
Basic Overview
Description | Returns the relative growth for each year compared to the previous year (year-over-year). |
Syntax | YOY_REL(Node <, MissingValueBehaviour>) |
Parameter |
|
Examples
Input Profit =
Year | Value |
---|---|
2019 | 200 |
2020 | 300 |
2021 | 450 |
2022 | 500 |
2024 | 100 |
Output YOY_REL('Profit') = YOY_REL('Profit', "IGNORE_MISSING")
Year | Value |
---|---|
2020 | (300 - 200) / 200 = 0.5 |
2021 | 150 / 300 = 0.5 |
2022 | 50 / 450 = 0.11 |
Here, the function outputs the ratio between the difference (between the input year and the following year) and the value of the input year. The output shows how many percent the input year value grew to the following year’s value. The missing year 2023 is simply ignored and its following year 2024 is consequently not calculated.
Output YOY_REL('Profit', "MISSING_AS_ZERO")
Year | Value |
---|---|
2020 | (300 - 200) / 200 = 0.5 |
2021 | 150 / 300 = 0.5 |
2022 | 50 / 450 = 0.11 |
2023 | (0 - 500) / 500 = -1 |
| (100 - 0) / 0 = division by zero results in entry not being present in result |
2025 | (0 - 100) / 100 = -1 |
In this example, the results are mostly the same, although the missing years 2023 and 2025 are calculated as having the value 0. This leads to negative values for 2023 and 2025, as well as a zero division error for 2024.
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())