Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How do I build a daily sales calculation based on previous day?

Topic Labels: Custom Extensions
553 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I currently have a spreadsheet in which I enter my daily sales records and bank balance for each day. I use the previous day data to calculate the bank balance difference and sales data. I was wondering if there is a way I can replicate the same behaviour with Airtable?

1 Reply 1

Here’s one way (but you need two extra columns to do it): You can have a “Previous Day” column which links to the previous day, but you need to set that manually for each row. Then use a Lookup field “Previous Day Balance” to pull the balance for the previous day. Then the current balance could be a formula which adds Today’s Sales (aggregated by sum using another Rollup field) plus Previous Day Balance.

It’s possible, but clunky, depending on how you structured your base.

Shameless plug: you might be interested in my product which syncs bank transactions to Airtable automatically: Fintable.io.