Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Using SUM in formula

Topic Labels: Formulas
2041 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Ilias_T
6 - Interface Innovator
6 - Interface Innovator

Hi.
Let’s say that every record has a field named: Cost. The sum of the cost of all records appear at the bottom. Can I use that sum in a formula? For example if I want to calculate the percentage of every record’s cost ( when 100% is the sum )

Thank you
Ilias

3 Replies 3
Wouter
5 - Automation Enthusiast
5 - Automation Enthusiast

It’s not easy I think…
Read this: How do I automatically add up all values in a column?

Wouter
5 - Automation Enthusiast
5 - Automation Enthusiast

Shorter description:

Add extra Sum table and under Name type Sum of Costs, so just one record in this table.
Now go to Cost table and add a field with link to the Sum table.
Link the first record to the one field.
Copy this to the other records.
In Sum table you add a Rollup field where you add up the costs from the Costs table.
Now in Costs table you add a Lookup field where you lookup the Rollup field from the Sum table.

The result is you get the sum of all Costs in every record. You can use this now for further calculation per record.

Ilias_T
6 - Interface Innovator
6 - Interface Innovator

Thank you. I was considering a solution of that kind but I asked in case I missed something that could have resolved it easier.
Thank you anyway !