View All Docs
Product overview
Account overview
Integrations
Transforms
Security
Hide Navigation
Product overview
Account overview
Integrations
Transforms
Security
Use case FAQs
Transforms →
Add running total

Add running total

🎁
$250 PRIZE
Enter the Custom Transform Contest
To celebrate this launch, we’re hosting a contest to highlight the creative ways our customers solve problems with this step. Show off your creativity for the chance to win $250 or Parabola swag! 

Click the link below to learn more and submit your entry. The contest closes on Friday, April 11 @ 5pm PST. 
Enter now

The Add running total step calculates the running total sum of any column you choose.

Running total for the entire table

This setting creates a running total column, each cell of which contains the sum of all cells in a specified column, up to the current row.

Running total for each value in a column

Switch the first setting from 'for the entire table' to 'for each value in this column' to create individual running totals for each unique value in another reference column.

For example, if you needed to create the running total for the number of steps each person took in a day, you would sum the values in the 'Steps' column and create a a running total for each value in the 'Name' column.

The column being referenced for grouping does not need to be sorted, but the results will be easier to read if that column is sorted.

Helpful tips

  • Any value that is not a number will be treated as a 0, including words and blanks
  • This step can sum: positive and negative numbers (-10), decimals (10.55), currencies ($50), percentages (10%), and scientific notation (10e2)
  • Percentages will be summed as their numeric format. So 10% will be summed as 0.1