Hi guys, I succeeded to create an inventory app. And to get the current inventory level, I used the formula COUNT([Related Purchases]) - COUNT([Related Sales]) + [Initial Stock].
However, when I add or reduce the stock by any amount for example 10, the current stock changes by just 1 digit. Current stock = 30, I add 20 stock. The current stock is supposed o show as 50. But it instead shows as 31. Please how do I fix this?
Thanks
For reference:
User | Count |
---|---|
33 | |
30 | |
30 | |
19 | |
17 |