saved search to show vendors that has multiple addresses

AI generated answer (using internal Slack threads):

To create a saved search to show vendors that have multiple addresses, you can follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Vendor from the list. 3. On the Criteria subtab, add a new criterion. Select

Address

from the dropdown and set the condition to

is not empty

. This will ensure that only vendors with an address are included in the results. 4. On the Results subtab, add the fields you want to display. For example, you might want to include

Name

,

Address

,

City

,

State

,

Zip

. 5. To show only vendors with multiple addresses, you will need to use a formula. On the Summary subtab, add a new line with

Formula (Numeric)

as the type. In the formula field, enter

COUNT({address})

. Set the summary type to

Group

and the sort to

Descending

. 6. Save and run the search. This will give you a list of vendors with the number of addresses they have. Vendors with multiple addresses will have a count greater than 1. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******