DELTA_ABS

Category: Compare periods

Overview

The DELTA_ABS function calculates the absolute difference between consecutive values within a selected dimension. The result is signed (current - previous), so values can be negative.

Use this function when you need the absolute change between consecutive values along any dimension, not just time.

Syntax

DELTA_ABS('Node', ["Dimension", ["FirstValueBehavior"]])

Example usage: DELTA_ABS('Revenue')

Parameters

FirstValueBehavior options:

• "SKIP_FIRST": The first value in each series is removed from the result. This is the default.

• "FIRST_AS_ZERO": The first value in each series is set to zero.

• "FIRST_VALUE": The first value in each series is kept as it is.

Output Shape

Watch Out

• The absolute difference is always calculated on the lowest available level of the specified dimension.

• The function compares only entries that actually exist in the input. Missing values are skipped. To calculate the absolute difference with filled missing values, use YOY_ABS for year-over-year, or fill gaps before calling DELTA_ABS.

• With SKIP_FIRST (default), series that contain only a single entry are dropped from the result entirely. Use FIRST_AS_ZERO or FIRST_VALUE to keep them.

• If the chosen Dimension's levels are linked from levels in another Dimension within the input, the calculation fails. In that case, calculate the delta on the linking Dimension instead.

• The result will use the same level links as those defined in dimension management. Do not use this function if your node needs level links that differ from the dimension's defaults.

Examples

Default: skipping first values

The function subtracts the value of the previous available entry from the current one, based on the order of the chosen dimension "Time". Missing entries are skipped, and the first entry per series is dropped.

Input node: Input node

Formula: DELTA_ABS('Input node') = DELTA_ABS('Input node', "Time", "SKIP_FIRST")

Product A's delta crosses zero: "ABS" means absolute (vs. relative) difference, not magnitude. Product C is missing from the output because it has only one entry, so SKIP_FIRST drops it.

First values as zero

Using the same input node as above. With FIRST_AS_ZERO, the first entry per series gets a result of 0 instead of being omitted, and single-entry series are preserved.

Formula: DELTA_ABS('Input node', "Time", "FIRST_AS_ZERO")

Product C now appears in the result with value 0 because its single entry is treated as a "first value".

Keeping first values

Using the same input node as above. With FIRST_VALUE, the first entry per series keeps its original value instead of being omitted or zeroed.

Formula: DELTA_ABS('Input node', "Time", "FIRST_VALUE")

Calculating deltas along a non-Time dimension

DELTA_ABS works on any dimension, not just Time. The example below uses a node that has only a Product level. Deltas are calculated along the Product order.

Input node: Sales

Formula: DELTA_ABS('Sales', "Product")

The first product (A) is dropped under the default SKIP_FIRST. Each subsequent value is subtracted from the previous one along the Product dimension's order.

Related Functions