exclusion in set analysis

[#1]

Hi

I have a table which looks like this

Field_A	Field_B
a	A
b	A
c	A
d	A
e	A
f	A
a	B
b	B
c	B

I want the list of Field_A items which are A but not B (which would be here "def")

I was thinking of doing something like :

=concat( {<Field_B={"A"} > -   <Field_B={"B"}> }   DISTINCT Field_A)

But it doesn't seem to work :

it returns "abcdef" instead of "def"

Could you help me out ?

Thanks !

[#2]

Great that's it ! thank you so much !

[sunny_talwar]

Awesome, I got to learn something new today. I did not know about this behavior, but now I do .

Thanks,

Sunny