Using the Cumulative Sum of a Column in a Formula

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.

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.

1 Like