Skip to main content

Subtracting items sold from sales table to inventory available table


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

Kamille_Parks11
Forum|alt.badge.img+25

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


  • Author
  • New Participant
  • 3 replies
  • August 12, 2021
Kamille_Parks11 wrote:

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




Kamille_Parks11
Forum|alt.badge.img+25
Gillian_Downey wrote:



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}


  • Author
  • New Participant
  • 3 replies
  • August 12, 2021

So here’s the roll up field I made…

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


  • Author
  • New Participant
  • 3 replies
  • August 12, 2021

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


Reply