Compare Item's Base Price to Purchase Price of Preferred Vendor through Saved Search

User would like to compare the Base Price of an Item against the Cost of the Preferred Vendor set in the Item record.

User created an Item Search and added the Preferred Vendor and Vendor Cost as a Column in the Results tab. However, the user is able to see multiple lines for the same item showing the Vendor Price of other vendors set in the Item record. User would only like to see one line for the Vendor Price of the Preferred Vendor.

To accomplish this, perform the following:

1. Navigate to Lists > Search > Saved Searches > New.

2. Select Item.

3. Provide Search Title.

4. In the Criteria tab > Standard subtab, add: Formula (Numeric).

5. Set Formula to:

Case when {vendor} = {othervendor} then 1 ELSE 0 END

Formula (Numeric) equal to 1

6. Click Save & Run.