AND function does not work

4 posts / 0 new
Last post
biwithse7en
Offline
Joined: 03/04/2020 - 11:03
AND function does not work

Hi,
I have a dilema with building this equation to extract certain items in my population.
My population contains the following column and I just want to extract [3] and [4] out.
Category
[1]
[2]
[3]
[4]
My equation is Category =="[3]" .And. Cateogory =="[4]". This is a valid equation, however my extraction is blank. I was able to extract individual [3] and [4].
does anyone know why? Any input would be appreciative.
Thank you.

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

.AND. means that they both have to be there to be true.  I think you are looking for .OR. as you are looking for transactions with a 3 or a 4 or both.

biwithse7en
Offline
Joined: 03/04/2020 - 11:03

Brian ElementYou Sir! are amazing. That fixed my problem. Thank you so much! 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Glad I could help.