Hello Everybody To calculate Current Inventory using virtual Column with this formula and it works fine
=SUM([tblPurchases][Quantity]) - SUM([tblSales][Quantity])
but now adding STATUS to the tblSales So need to calculate only the ones with status is “SHIPPED” not “READY”,
What would be the formula? Thanks
LinkedIn
Twitter
