Hello Everybody To calculate Current Inventor...

[Jason_F]

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

[Steven_Coile]

I’m not sure it can be done using lists, unless you also define and instead use lists that include the additional selection criteria. For instance, define the columns tblPurchasesShipped and tblSalesShipped.

[Aleksi_Alkio]

@Jason_F You can do that like…

SUM([tblPurchases][Quantity]) - SUM(SELECT([tblSales][Quantity],[STATUS]=“Shipped”))

[Steven_Coile]

@Aleksi_Alkio Neat!!!