YOY_ABS
Category: Compare periods
Overview
Description | Returns the absolute growth for each year compared to the previous year (year-over-year). Use this when you need the absolute difference between the current and previous year’s value. |
Syntax |
|
Parameters |
|
Examples
Default: ignoring missing values
This example shows YOY_ABS with the default behavior. Years without data (2029) are skipped.
Input node: Profit
Year | Value |
|---|---|
2025 | 200 |
2026 | 300 |
2027 | 450 |
2028 | 500 |
2030 | 100 |
Formula: YOY_ABS('Profit') = YOY_ABS('Profit', "IGNORE_MISSING")
Year | → YOY_ABS Result |
|---|---|
2026 | 100 |
2027 | 150 |
2028 | 50 |
Treating missing values as zero
With MISSING_AS_ZERO, gaps are filled with 0, producing results for every year including those without input data.
Formula: YOY_ABS('Profit', "MISSING_AS_ZERO")
Year | → YOY_ABS Result |
|---|---|
2025 | 200 |
2026 | 100 |
2027 | 150 |
2028 | 50 |
2029 | -500 |
2030 | 100 |
2031 | -100 |
Related Functions
Function | When to use instead |
|---|---|
When you need the percentage change year-over-year instead of the absolute difference. | |
When you need the absolute change along any dimension, not just time (e.g. compare across products). | |
When you need compound growth over multiple periods, not just a single-period comparison. |