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 |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |