Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi Sunny,
thanks, but none of them give any result.
thanks
vijay
Would you be able to share a sample?