How to make calculations in two tables using currency fields

I’m brand new to Airtable and getting to grips with it all so forgive me if this is a simple and stupid question.

I’ve got a table logging expenses by two people. I’m using a currency field to add the amounts spent by each person.

Now I want a second table that shows the overall funds both people start out with and then a field that shows the current funds available which updates according to the expenses logged in the expenses table.

Can someone explain to me how to do that? I don’t even know what sort of keywords to look for in the help sections.

Thank you so much for any help!

Assuming each record in your Expenses table is linked to a table for People, the People table could include a Rollup-type field to add up all the values from your currency field for the records linked to each particular person using SUM(values).

If your People table has a “starting value” currency field, you could use a formula field to subtract all the expenses from the starting value: {Starting value field name} - {Expenses rollup field name}

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.