Math & Statistics icon

Math & Statistics

Calculate safe allowlisted math and statistics operations for finance datasets.

Actions8

Finance Math → Growth Rate

AI-generated

Summary

Calculate the percentage growth rate of numeric data either by comparing the first and last valid values in a single numeric column across rows, or by calculating growth for each row between two specified columns representing start and end values.

Inputs

  • Growth Mode (required) — Choose whether to calculate growth rate between the first and last valid value in a single column ('Between First and Last Value'), or between two specified columns for each row ('Between Start/End Columns').
  • Growth Value Column (required) — Numeric column to use when calculating growth rate between the first and last valid values (used when Growth Mode is 'Between First and Last Value').
  • Growth Start Column (required) — Start-value column for row-level growth calculations (used when Growth Mode is 'Between Start/End Columns').
  • Growth End Column (required) — End-value column for row-level growth calculations (used when Growth Mode is 'Between Start/End Columns').

Output shape

a single JSON object summary or detailed per-row results depending on Growth Mode

If Growth Mode is 'Between First and Last Value', returns an object with the growth rate calculated between the first and last valid entries of the specified Growth Value Column, including counts of valid and ignored values and any division-by-zero warnings. If Growth Mode is 'Between Start/End Columns', returns an object with per-row growth rate calculations between the specified start and end columns along with counts of valid and ignored rows and any division-by-zero warnings.

Examples

Example 1: Calculate overall growth rate from first to last valid value in a column

Set Growth Mode to 'Between First and Last Value' and specify the Growth Value Column name containing the numeric data.

Example 2: Calculate row-level growth rate between two columns

Set Growth Mode to 'Between Start/End Columns' and specify the Growth Start Column and Growth End Column names to compare values row-wise.

Links

Discussion