RE: Can I create a saved search to identify available inventory at 2 separate inventory locations in one search?
I need to create a saved search based on criteria at 2 different inventory locations.
Specifically identifying items available greater than or =1 at location 1 and inventory available = 0 at location 2. I am stuck and horrible with expressions
not sure how complex your rules are, hopefully this helps
use a numeric formula on criteria where value =1 ……… when the “when” statements are =1 then your rules are met.
case when {inventorylocation} like ‘%Quiet%’ and {locationquantityavailable} =0 then 1 when {inventorylocation} like ‘%Beac%’ and {locationquantityavailable} >1 then 1 else 0 end
