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.
Using the Cumulative Sum of a Column in a Formula
+17Hi @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
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.