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
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.
@Jason_F You can do that likeโฆ
SUM([tblPurchases][Quantity]) - SUM(SELECT([tblSales][Quantity],[STATUS]=โShippedโ))
@Aleksi_Alkio Neat!!!
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |