Item Saved Search to show zero for null value for Location Quantity on Hand

To show zero for null value for Location Quantity on Hand in Item Saved Search,

1. Create Item search
2. Provide the required criteria
3. On the results tab, along with other columns add the following formula

Formula (Numeric)
CASE WHEN {locationquantityavailable} is null THEN 0 ELSE {locationquantityavailable} END 

4. Click Save & Run