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…
Subtracting items sold from sales table to inventory available table
This topic has been closed for replies.
+27Would you be able to post a screenshot of each table?
+27
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…
Then when I put in the formula for quantity in the sales section it says there is an error…
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.