i am missing something obvious here but cannot put my finger to it, i am trying to get a saved search that shows lines that are not fully fulfilled but results still shows me Quantity = Quantity fulfilled/received case when {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) > 0 then 1 else 0 end