Is Null with Set Analysis

[jagjivvt]

Hi,

I am using the following expression but it does not provide any result.

round(count({$<Region ={'(=isnull())'} >} distinct EmpNo) / count({$<EmpNo >} distinct EmpNo),0.01)

if I use a if statement the it does, but need to use set analysis.

count(DISTINCT(if(isnull(Region)=-1, EmpNo, null())))/count(DISTINCT(EmpNo))

thanks

Vijay

[sunny_talwar]

Try this:

Round(Count({$<Region ={"=IsNull(Region)"} >} Distinct EmpNo) / count({$<EmpNo >} Distinct EmpNo), 0.01)

or

Round(Count({$<Region ={"=Len(Trim(Region)) = 0"} >} Distinct EmpNo) / count({$<EmpNo >} Distinct EmpNo), 0.01)

[jagjivvt]

Hi Sunny,

thanks, but none of them give any result.

thanks

vijay    

[sunny_talwar]

Would you be able to share a sample?