> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Month-over-month growth rate

> Scenario: calculate MoM order growth.

**Scenario**: calculate MoM (month-over-month) growth for orders.

**Data**: \[Month] field: 1-12; \[Order count] field.

**Steps**

1. Add helper field \[MoM helper] with formula `[Month]-1`.

![](https://img.alicdn.com/imgextra/i2/O1CN0145lI4y1Gx9da0aPq8_!!6000000000688-2-tps-1836-1016.png)

2. Use lookup to add \[Order count\_lagged] referencing \[Order count]; lookup condition: \[Month] = \[MoM helper]; aggregation: original value.

![](https://img.alicdn.com/imgextra/i1/O1CN01DRQ0YI1MfeBzKrROy_!!6000000001462-2-tps-1836-1016.png)

3. MoM growth rate formula: `IFERROR(([Order count]-[Order count_lagged])/[Order count_lagged],"")`.

![](https://img.alicdn.com/imgextra/i4/O1CN01mBqyUv1lje2klUX9Q_!!6000000004855-2-tps-1836-1016.png)