Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Subtracting items sold from sales table to inventory available table

Topic Labels: Formulas
1541 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Gillian_Downey
4 - Data Explorer
4 - Data Explorer

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}

Gillian_Downey
4 - Data Explorer
4 - Data Explorer

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

Gillian_Downey
4 - Data Explorer
4 - Data Explorer

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