Item Search where Preferred Vendor Price is greater than the Base Price by a Certain Amount

1. Navigate to Reports> Saved Searches> All Saved Searches> New

2. Select Item as search type

3. Assign a name on the Search Title field

4. On the Criteria tab> Standard sub tab, set the following:

a. Formula (Numeric) is greater than value 10, then copy-paste this formula:

{vendorcost}-{price}

b. Formula (Text) is YES then copy-paste this formula:

Case when {vendor}={othervendor} then 'YES' else 'NO'end

5. On the Results tab> Columns sub tab, add the columns that you wanted exposed on the search

6. Save & Run.