Creat fiels to show something

Topic Labels: Formulas
843 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

i create one base that showing income -expenses-profit
every thing is good
now i have one problem, i create one field name is bank balance.i put formula in field that( total bank balance(30000) + Profit),problem is now this field ,every row doing - from 30000
i want every row should make - from last field row

1 Reply 1

I think you are making the mistake of trying to use Airtable like a spreadsheet, when it is actually a database.

One way of achieving what I think you’re trying to achieve would be to have two tables: Transactions and Accounts. Your Transactions table would contain every transaction in a separate field. So a profit would be positive (e.g £200) and an expense would be negative (e.g -£50). Each transaction would be linked to an account in the Accounts table using a Link to Record field. You could then use a Roll up field in the Accounts table to sum up the balance of all transactions for that account.