Skip to main content
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.
  2. Use lookup to add [Order count_lagged] referencing [Order count]; lookup condition: [Month] = [MoM helper]; aggregation: original value.
  3. MoM growth rate formula: IFERROR(([Order count]-[Order count_lagged])/[Order count_lagged],"").