Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] )
Try like:
count({<src_call_nm= {"=Len(trim(src_call_nm))>0"}>} distinct [MDM ID] )
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?
Hi
Try :
count({<src_call_nm-={' '}>}distinct [MDM ID])
or
count({<src_call_nm={">=$(Len(trim(src_call_nm)))"}>}distinct [MDM ID])
HTH
Sushil
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
Thanks a ton, Its working fine
Thanks a ton, Its working fine