Community
Showing results for 
Search instead for 
Do you mean 
Reply

Dynamic groups using "AND" & "OR"

Accepted Solution Solved
New Member
Posts: 11
Country: canada
Accepted Solution

Dynamic groups using "AND" & "OR"

Been having some issues with Dynamic groups.  Just wondering what the easiest way to create groups with multiple AND and OR fields.

 

Basically I want find all architects in multiple regions.  I initially had designed it like:

 

if field = architect AND territory = A OR Territory = B OR territory = C. This did not work as it included all members of Territories A and B 

 

I had to go 

 

if field = architect AND territory = A OR field = architect AND Territory =B OR  field = architect AND Territory = B  

 

This gets rather long and cumbersome especially if you want two different fields to be included. 

 

IS there any way to streamline This process?

 

thanks in advance


Accepted Solutions
Solution
Accepted by topic author mimmo_l
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Dynamic groups using "AND" & "OR"

Did you use parenthesis to group and control the evaluation of the query?
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Solution
Accepted by topic author mimmo_l
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Dynamic groups using "AND" & "OR"

Did you use parenthesis to group and control the evaluation of the query?
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129