Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a small proplem that I am having some problems solving. I have to find items that have not been sold for the last 120days but are avl in our warehouse.
I found a thread here that helped me find the items with no sales. But I do not know how to add the second measure to the mix.
This is the expression
Count({<[ItemNo]={"=Sum([120 days sales]) = 0"}>} distinct [ItemNo])
So any hints on adding InventoryQty !=0 ?
Regards and Merry Christmas
Birkir
Maybe like
Count({<[ItemNo]={"=Sum([120 days sales]) = 0 and Sum(InventoryQty)<>0"}>} distinct [ItemNo])
Maybe like
Count({<[ItemNo]={"=Sum([120 days sales]) = 0 and Sum(InventoryQty)<>0"}>} distinct [ItemNo])
Hi Stefan and all,
Thank for your input this works like a charm, thanks for the assistance and Merry Christmas
Regards
Birkir