Count in set analysis

[chaitanyajami]

Hi all,

I want to calculate the number of MDM ID'd that have call count ( count(src_cal_nm)>0)  greater than "0", i am using below expression but could not achive it, can some one suggest me with the correct formula  to achieve it.

count({<src_call_nm-={"$(Null())"}}>}distinct [MDM ID])

or

count({<[MDM ID] = {"=Count([src_call_nm])>0"}>} distinct [MDM ID] )

[tresesco]

Try like:

count({<src_call_nm= {"=Len(trim(src_call_nm))>0"}>} distinct [MDM ID] )

[jonathandienst]

Tresesco's solution should work, but you might also be able to use:

Count({<[MDM ID] = {"=$(=Count([src_call_nm])>0")}>} distinct [MDM ID])

But this depends on the relationship between the two fields - does the count differ for each distinct MDM ID value?

[sushil353]

Hi

Try :

count({<src_call_nm-={' '}>}distinct [MDM ID])

or

count({<src_call_nm={">=$(Len(trim(src_call_nm)))"}>}distinct [MDM ID])

HTH

Sushil

[chaitanyajami]

Hi Jonathan,

Yes those are related fields, one ID may have more than one call id, i need to calculate number of mdm id's that have call count greater than 0

[chaitanyajami]

Thanks a ton, Its working fine

[chaitanyajami]

Thanks a ton, Its working fine