I am having issues counting and adding/subtracting from the inventory product list when dealing with the over the counter products.
Name of table [Receiving]
Thanks for the help, I have been struggling for the past 2 days figuring out this problem.
I do not know where you are wanting this result to be, or when you want it to calculate, but you can calculate this total quantity with something like:
SUM( SELECT(
Table[Quantity] ,
AND(
[Expiry Date] = #another expiry date to compare against#
[Product Name] = #another product name to compare against#
)
))
I donโt really understand what youโre wanting here. How do you expect to do this? Are you editing data directly? Are you adding in new records for using up items? Perhaps you need to review a typical inventory sample app?
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |