Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
flottmen
Contributor
Contributor

Nested Advanced Search

I am trying to write an expression that counts records from affiliates that have a minimum count.  This requires me to do a nested Advanced Search as follows:

Count({$<Affiliate|Channel={"=Count({$<DeliveryStatus={'D','O'}, LeadType-={'Leadborghini', 'Master Vendor'}, Affiliate-={"*Test*", "*Higher Ed*", "*Google*", "*AC Targeting*"}, Affiliate=, Channel=>}LeadId)>=250"}>} LeadId)

The Affiliate portion of the is giving me trouble because of the double quotes.  Is there a way to accomplish this?

1 Solution

Accepted Solutions
luismadriz
Specialist
Specialist

Hi Eric,

Maybe this: [*Test*], [*Higher Ed*], [*Google*], [*AC Targeting*]

View solution in original post

2 Replies
luismadriz
Specialist
Specialist

Hi Eric,

Maybe this: [*Test*], [*Higher Ed*], [*Google*], [*AC Targeting*]

flottmen
Contributor
Contributor
Author

Totally worked.  Thank you.