Help

How can I perform a calculation from the values that were returned in a lookup field

Topic Labels: Formulas
Solved
Jump to Solution
873 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AUTORRARI_MAIN
7 - App Architect
7 - App Architect

So I’m not sure how to ask it differently, but if I were to try, here it goes.

NEW to Airtable (so TY for being patient & detailed)

So I have a base with three tables in it, Customers, Vehicles & Sales. I’m trying to collect all of the sales for each customer. All of the tables are linked, and I have been able to bring each of the sales into one cell (example: $0.00, $170.00, $125.00). But now I need to total those numbers!

Any help would be greatly appreciated!

DG

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable commumity.

Try using a rollup field instead of a lookup field.To get the sum of the values, use the rollup formula SUM(values)

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable commumity.

Try using a rollup field instead of a lookup field.To get the sum of the values, use the rollup formula SUM(values)