Search to pull list of items with a specific price level with zero or null values

Search to pull list of items with a specific price level with zero or null values

--Navigate to Lists > Search > Saved Searches > New > Item

--On the criteria tab > standard sub tab >  select Formula (Numeric) > Formula=CASE WHEN NVL({pricelevel1},0)<=0 THEN 1 ELSE 0 END

Equal to 1.

**Pricelevel1 = where 1 is the Internal Id of the Price Level

--Rename you search, Save & Run.

Did this help? If not, try contacting us Submit a request

Comments