Skip to main content
Skip table of contents

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()) .

JavaScript errors detected

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

If this problem persists, please contact our support.