Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Great that's it ! thank you so much !
Awesome, I got to learn something new today. I did not know about this behavior, but now I do .
Thanks,
Sunny