Summing record within one table

Hi!

I’m new to Airtable, trying to make a monthly budget, and I started with the “Small business budget” template. I want the end of month balance for each month to roll over to the next month, but I can’t figure out how to do that. In Excel, I would use a formula referencing the previous end of month balance for the next one (eg: end of month balance = {Income (actual)} + {Previous end of month balance} - {Expenses (actual)} )

Do I need to create a new table with lookup or rollup fields? How can I reference the end of month balance for each month separately?

Thanks so much.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.