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?
Here’s a look at the base in question: Airtable - Grid view.