MOM_ABS

Category: Compare periods

Overview

Description

Returns the absolute growth for each month compared to the previous month (month-over-month).

Use this when you need the absolute difference between consecutive months.

Syntax

MOM_ABS('Node' [, "MissingValueBehaviour"])

Parameters

Node: Input node, specified using the node name in single quotes (e.g. 'Profit')
MissingValueBehaviour (optional): How missing values are treated.
- "IGNORE_MISSING" - Missing rows are skipped. This is the default.
- "MISSING_AS_ZERO" - Missing rows are treated as 0.

This example shows MOM_ABS with the default behavior. The missing months are skipped and no result is produced for them.

Input node: Profit

Formula: MOM_ABS('Profit') = MOM_ABS('Profit', "IGNORE_MISSING")

With MISSING_AS_ZERO, gaps are filled with 0, producing results for every month including those without input data.

Formula: MOM_ABS('Profit', "MISSING_AS_ZERO")

Function	When to use instead
MOM_REL	When you need the percentage change month-over-month instead of the absolute difference.
YOY_ABS	When you need the absolute difference on a yearly basis instead of monthly.
DELTA_ABS	When you need the absolute change along any dimension, not just time.