Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for
Did you mean:
Creator

How to use Isnull() function in Set analysis

Hi Team,

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

21 Replies
Creator
Author

Hi Anil,

Here I want count of B where A is null.

Master II

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

OR

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

Learning never stops.

Looks like, This is working?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

Master II

This didn't work ?

Learning never stops.
Creator
Author

Anil, How can we use it in set analysis?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

Great Anil. Thanks..

Contributor II

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

Partner - Creator

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 !

Community Browser