Distinct Count of only filled in values

[linar]

Hello,

I want to perform a distinct count of a
formula that can return a number, but it can't also return empty or zero. The problem is that I don't want to include the empty values in my distinct count.

Example:
my formula returns :
600601
600602
600603
null
null

My Distinct Count on this formula returns 4.
But I want it to be 3 ! I know about the IsNull function, but I haven't succeeded yet to use it in a correct way.

Ideas ?

Thanks
Lina

 

[linar]

I already found my problem.
It's described in

http://www.kenhamady.com/form14.html

Thank you Ken Hamady!

bye