Luis
09/11/2024, 4:59 PMCeligo AI
09/11/2024, 4:59 PMAI generated answer (using internal Slack threads):To get all customers with more than 10 addresses in a saved search, you would need to create a saved search in NetSuite with the following criteria: 1. Record Type: Customer 2. Criteria: - Address: Count (Summary Type) > 10 This will return all customers who have more than 10 addresses associated with their account. Please note that the 'Address: Count' field is a summary field, so you need to use it in the 'Results' tab of the saved search, not in the 'Criteria' tab. Also, remember to set the 'Summary Type' to 'Count' for the 'Address' field. This will count the number of addresses associated with each customer. Then, in the 'Criteria' tab, you can add a new 'Formula (Numeric)' criterion. In the formula field, enter
case when {address.count} > 10 then 1 else 0 end
, and set the condition to 'is greater than' and the value to 0. This will filter out the customers who have 10 or fewer addresses.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
09/11/2024, 5:00 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.829295516
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.81453371
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.810480535
Celigo AI
09/11/2024, 5:00 PM