Community
Showing results for 
Search instead for 
Do you mean 
Reply

Explanation of Why Two Advanced Lookups Give Different Answers

Accepted Solution Solved
Bronze Super Contributor
Posts: 1,488
Country: USA
Accepted Solution

Explanation of Why Two Advanced Lookups Give Different Answers

I recently created the following lookup:
 
Option #1
Contact  --  E-mail  --  Contains Data  --  Nothing  --  and
Contact  --  E-mail  --  Does Not Contain  --  Opt Out  --  And
Contact  --  E-mail  --  Does Not Contain  --  OptOut  --  And
 
but
 
Option #2
Contact  --  E-mail  --  Contains Data  --  Nothing  --  and
( Contact  --  E-mail  --  Does Not Contain  --  Opt Out  --  or
Contact  --  E-mail  --  Does Not Contain  --  OptOut  --  And )
 
Option #1 gave the correct answer, but Option #2 continued to include the Opt Out variations. 
 
It's probably my not understanding the rules of Boolean logic.  If so, I would welcome the explanation.
.

 

John Purdy
ACT! Premium V. 20.0.159
HP ENVY 17m, 16GB, & Office 365, 32bit, 1TB HDD.

Accepted Solutions
Highlighted
Solution
Accepted by topic author jnpurdy
‎08-07-2019 03:22 PM
Platinum Elite Contributor
Posts: 6,853
Country: USA

Re: Explanation of Why Two Advanced Lookups Give Different Answers

In the first example the statements are evaluated in order. In the second example the statements two and three are evaluated first because they are enclosed in parenthesis.
Roy Laudenslager
Retired 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
Highlighted
Solution
Accepted by topic author jnpurdy
‎08-07-2019 03:22 PM
Platinum Elite Contributor
Posts: 6,853
Country: USA

Re: Explanation of Why Two Advanced Lookups Give Different Answers

In the first example the statements are evaluated in order. In the second example the statements two and three are evaluated first because they are enclosed in parenthesis.
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Bronze Super Contributor
Posts: 1,488
Country: USA

Re: Explanation of Why Two Advanced Lookups Give Different Answers

Thanks Roy.  

John Purdy
ACT! Premium V. 20.0.159
HP ENVY 17m, 16GB, & Office 365, 32bit, 1TB HDD.