Set analysis > count those F2 fields which have no partner in F1

[#1]

Hello QVer,

F1 | F2
AB | 1
CD | 2
| 3
GH | 4
| 5
KL | 6
I have a table and I want to count those F2 values which have no partner in field F1 and I want to do it with set analysis formula.
My litte example should give 2 (two values of field F2 have no partner in F1).
Can somebody help please? Thanks.

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

If you load from an inline or depending on how your driver deals with nulls, this should work

=Count({< F1 = {"=Len(F1) = 0"} >} F2)

If it's a real null (non-existent) value, the following should work

=Count({1 - < F1 = P(F1) >} F2)

Hope that helps

[brenner_martina]

Hi,

you need the modificator E(), look at the attached example.