I have built a base that calculates individual client spending for four different years. Each client is a record, and contains the spending for each year, so essentially I have four yearly spending columns, and I need to access the total yearly spending (aka the vertical sum of each of those fields.) I know that airtable automatically shows what those sums are at the bottom of the table, but I need those numbers for year over analytics, and it seems that there is no way to retrieve that sum in the software. Another thing that I am struggling with is getting a numerical count of records, something akin to the “countif” function in excel. I just need to do basic analytics, like divide the yearly total by number of clients, or find percentage difference in spending between years, and I would like to do that within airtable. I can’t figure out how to do those things with blocks either. I understand that airtable is a “relational database” and not a spreadsheet, but it seems ridiculous that there is no way to do even BASIC operations and analytics.
Is there something that I’m missing?