Help

Using the Cumulative Sum of a Column in a Formula

Topic Labels: Formulas
4189 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Tiffany_Perdue
4 - Data Explorer
4 - Data Explorer

I’d like to use the cumulative sum of one of my columns in a formula. Is that possible?
Essentially, I want to use the sum of the column “material amount” divided by the column “goal” which is fixed at 3,500,000 to determine in the column “% of my goal” the ongoing percentage of my goal I am at in any given time period.

2 Replies 2

Hi @Tiffany_Perdue,

Welcome to Airtable Community!

The short answer to your question is Yes you can but not in a direct way.

You will need to define an item that is repetitive in records that you want to Sum up. Create a Linked Field to another record and use the Rollup option.

BR,
Mo

Possible alternative - a script block that simply performs the computations and writes the product into a record/cell of your choosing.