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