Distinct count only non-blank cells

[JustinM]

Hi

I'm trying to distinct count a column of cells but ignore the cells with blank values.

I've tried this

Count({<sRefNo = {"=Sum(sRefNo) = 0"}>}DISTINCT sRefNo)

which works to count but it includes the blank in the answer

The below attempt says I'm missing a ")"

Count(if(not isnull(sRefNo),distinct sRefNo))

Please help

[Anil_Babu_Samineni · Accepted solution]

Perhaps this for second one?

Count(distinct if(not isnull(sRefNo), distinct sRefNo))

Or

Count({<sRefNo={"=Len(sRefNo)>=0"}>} sRefNo)

[JustinM]

Much appreciated. It worked. The only change I made to yours was the "=Len(sRefNo)>=0" changed to "=Len(sRefNo)>0"