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

[AUTORRARI_MAIN]

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

[kuovonne · Accepted solution]

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)