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