Skip to Content
0
Jan 24, 2011 at 10:47 PM

distinct count that ignores NULL

1488 Views

I am trying to do a distinct count of a field but I do not want any NULL rows to be counted. Any ideas on how to accomplish this?

I have created a formula field that returns a date from a different field if certain criteria are met. If not, it returns " ". Now I need to get a distinct count of the dates. I am not very experienced using Crystal and this has me stumped.