How to convert negative values into zeros in Saved Search

We can convert all negative values into zeros in Saved Search using the following :-

1. ) Navigation : Lists > Search > Saved Search > New > select the type of search

2. ) On the Results tab > Column subtab ;

Field = Formula (Numeric)

Formula = CASE WHEN {field for comparsion} < 0 THEN 0 ELSE {field for comparsion} END

3. ) Save and Run

For example,

CASE WHEN {Qty to Order} < 0 THEN 0 ELSE {Qty to Order} END