How to use Isnull() function in Set analysis

[vipingarg23]

Hi Team,

How can we implement Isnull() function in Set analysis?

[vipingarg23]

Hi Anil,

Please find the sample file.

Here I want count of B where A is null.

[pradosh_thakur]

Count({<B={"=(len(trim(B))=0)"}>}A)

OR

Count(DISTINCT {<B={"=(len(trim(B))=0)"}>}A)

[Anil_Babu_Samineni]

Looks like, This is working?

Count(If(Len(A)=0,B))

[vipingarg23]

Great Anil, It is working fine..Thanks for your quick reply.

[pradosh_thakur]

This didn't work ?

[vipingarg23]

Anil, How can we use it in set analysis?

[Anil_Babu_Samineni · Accepted solution]

Count({<A = {"=Len(A)=0"}>} B)

[vipingarg23]

Great Anil. Thanks..

[MohitSharma3110]

I don't think this is working, as how can we compare value of A with a condition equaling length of that field =0. if we have below example values of table:

A         B
1         100
NULL 200
Then how can we do this set analysis when A= {"=Len(A)=0"}>}. 

[john_oll]

Count ( { $ - < B ={"*"} > } A)
Is the correct solution.
Take everything and subtract the non-null() values, and your result is only the isnull() values.

Credits to teempi !