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

1) Navigate to Lists > Search > Saved Searches > New > Item

2) 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 your search, Save & Run.

Leave a comment

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