MOM_ABS

In Compare periods

The MOM_ABS function returns the absolute growth for each month compared to the previous month (month-over-month).

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

Parameters

NodeNode referenceRequired

Input node, specified using the node name in single quotes (e.g. 'Profit')

MissingValueBehaviourKeywordOptional

How missing values are treated. Default: "IGNORE_MISSING".

• "IGNORE_MISSING": Missing rows are skipped. This is the default.
• "MISSING_AS_ZERO": Missing rows are treated as 0.

Examples

Default: ignoring missing values

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')

Equivalent to: MOM_ABS('Profit', "IGNORE_MISSING")

Treating missing values as zero

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")

See also

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.