I want to create a cumulative balance field.

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

Hello. I've been studying airtable lately.

I'm trying to express a sheet in Excel with an airtable, but I want to create a cumulative balance field, but I don't know how.

Is there any way to find the balance of this row after adding or subtracting this row's income or expenses from the previous row's balance? Please advise.

1 Reply 1

Kind of, Airtable has rollup fields:

Screenshot 2024-05-14 at 11.23.34 PM.png

Screenshot 2024-05-14 at 11.23.43 PM.png
Link to base

I'd recommend googling Airtable Rollup fields and checking out some quick videos to see how they work!