I am a lifetime Excel user, so forgive me thinking like a spreadsheet and not a database, but…here is my problem:
I manage an Oyster farm. I have a table that logs the oysters that are harvested. I have another table for the demand for the oysters. I want to net the two against each other and see whether I have enough.
As my table of Harvested oysters is set up so each day the team either enters the number of oysters they harvested (a positive number) or the number of oysters they delivered (a negative number). Thus, choosing “sum” at the top/bottom of each column will show me exactly how many oysters I have (summing all the postive/negative numbers to date).
And as my table of Demand for oysters shows the number of oysters requested by each client on each date, I can group those by day/week/month, and look again to the “sum” of the column to see how many oysters are needed.
But I can’t see how I create the Sum of all the oysters I have (the sum of Harvested Oysters table) less the sum of the Demand for oysters table. If I was working in Excel I would simply enter the formula: sum(column X) - sum (column Y).
I assume I cannot directly access the numerical “sum” that Airtable shows me for a column, but is there anyway to get that number?
Again, all I want to do is subtract the sum of one field over a bunch of records from the sum of another field over a bunch of records.