Skip to main content
Solved

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

  • February 11, 2022
  • 1 reply
  • 29 views
A
Forum|alt.badge.img+10

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

Best answer by kuovonne

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)

1 reply

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • Answer
  • February 11, 2022

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)

A
Terms & ConditionsAccessibility statement