AND function does not work

biwithse7en

Forums

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 Wed, 03/04/2020 - 11:26

.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.