PercentChange
Computes the percentage change from one row to the next, the growth rate between consecutive periods. Results are in percent (a move from 100 to 105 shows as 5, not 0.05), ready to chart or report directly. The first row is 0, since there is no prior period.
Inputs
| Input | Accepts | Required |
|---|---|---|
Series | Series (a list of numbers) | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Series (a list of numbers) |
Example
Quarterly Revenue reads 2,400,000, 2,520,000, 2,470,000, 2,717,000. PercentChange produces 0, 5.0, -2.0, 10.0: quarter-over-quarter growth. Wire the result into a line chart with the quarter labels on the horizontal axis to show whether growth is steadying or accelerating, or run it through Round (Decimals 1) before writing it into an output table next to the raw figures.
Tips
Whether the result reads month-over-month, quarter-over-quarter, or year-over-year depends entirely on what one row represents in the source. For year-over-year from monthly data, first aggregate to annual figures with GroupBy. If a prior-period value is exactly zero the change is undefined and that row is left blank. Rows must be in period order; Sort upstream if needed.