I need to have the formula to calculate the total revenue and profit from my sales records table, which has been linked to my product inventory table. The aim of this set up is to update records automatically with every sale.
Question
Formula
+1
+28Hey, what you are looking for is probably a Rollup Field. You can read more about Rollup fields here: https://automaticnation.com/airtables-rollup-field-a-quick-guide/
Would you mind sharing some more details on your base structure?
+31Ah, I do’nt think this is possible with a formula I’m afraid. We can see the totals at the bottom of the screen like this:
And if we want to actually use that number, say in an email or something, then we’d need to create a new table and have a single record that’s linked to all the data records. This would allow us to create a rollup field like this:
I’ve set it up here for you to check out
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.