Re: Calculation when multiple records can be selected

718 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I am working a field trip application to organize field trips for my school. Airtable is definitely game changer for this!
I met a problem on my budget tab:

  • For each grade I have a total budget
    I can select the trip record from another TAB on a column named TRIPS for each grade
    The TRIPS cell can allow multiple records from the tab TRIP (if my grade 1 are doing 3 trips, we can select the three trips)
    I pull the total cost from all those trips.
    I need to show the remaining budget for each grade by a simple operation: budget - (total costs of all trips)
    But the problem is that the total costs for each trip are all in one cell. What should I do?


2 Replies 2

You need to use a Rollup field instead of a Lookup field, with the formula SUM(values)

I’ve never used Roll up, I will look into it.