I’m creating a database to track all cash activities (inputs and outputs) from a cash box at the office.
I’d like to have a column where we keep track of the total remaining balance after each transaction, whether it was an input or output, on the same base.
A formula that I’d like to replicate is Remaining Balance = Previous Balance - Debit + Credit. How would you do that in Airtable?
Since you can’t calculate things across records, I simply add a third formula field where I calculate the balance per record: IN field - OUT field. That way, you can make the summary in the bar below your records (or per IN/OUT if you group them). Would that work for you?