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

Subtracting items sold from sales table to inventory available table

Topic Labels: Formulas
467 5
Showing results for 
Search instead for 
Did you mean: 

I am trying to make a simple sales table that will communicate with my inventory table to subtract what is sold and show me how much inventory I have left. I don’t understand most of the lingo…

5 Replies 5

Would you be able to post a screenshot of each table?

In your Inventory table, add a rollup field that aggregates the Sales table’s {Quantity} field. For the aggregation formula use SUM(values)

Turn your {Amount in Stock} field into a formula field that uses this formula {Quantity Purchased} - {Name of your rollup field}

So here’s the roll up field I made…

Screen Shot 2021-08-12 at 12.35.37 PM

Then when I put in the formula for quantity in the sales section it says there is an error…

Screen Shot 2021-08-12 at 12.34.15 PM

omg never mind! I got it!!! THANK YOUUU