Display Quantity Available less than 10 as 0 in a saved search

List>search>Saved searches >New

Under the Result, Tab Give the Fields as shown below

Name

Available ( this shows the available quantity of the items)

Formula (Numeric) : CASE WHEN {quantityavailable}<10 THEN 0 ELSE {quantityavailable} END (under the formula option)

Here the quantity available is 0 for the available quantity less than 10.

Leave a comment

Your email address will not be published. Required fields are marked *