2 Replies Latest reply: Dec 27, 2017 9:54 AM by Birkir Bjornsson RSS

    How to find Items with zero sales but avl inventory

    Birkir Bjornsson



      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