Skip to main content
Skip table of contents

MOM_ABS

Basic Overview

Description

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

Syntax

MOM_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 =

Month

Value

2019-01

200

2019-02

300

2019-03

450

2019-04

500

2020-02

100

Output MOM_ABS('Profit') = MOM_ABS('Profit', "IGNORE_MISSING")

Month

Value

2019-02

100

2019-03

150

2019-04

50

Output MOM_ABS('Profit', "MISSING_AS_ZERO")

Month

Value

2019-01

200

2019-02

100

2019-03

150

2019-04

50

2019-05

-500

2020-02

100

2020-03

-100

JavaScript errors detected

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

If this problem persists, please contact our support.