Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Subtracting items sold from sales table to inventory available table

Topic Labels: Formulas
2008 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