I will give it a try Wednesday night and let you know.

Thank you.


>So, can you do...
>
>COUNT(CASE WHEN Date = somethingYouWant THEN Date ELSE null END)
>
>???
>
>BOb
>
>
>>You are correct it will ignore nulls. The problem is that the field that I need to do a distinct count on will always be populated. I need the count to be based on the date field. The dates maybe the same but are mostly different dates.
>>
>>NOI1234-00 Null
>>NOI1234-00 Null
>>NOI1234-00 2003-05-12 00:00:00.000
>>NOI1234-00 2003-04-12 00:00:00.000
>>
>>The formula would return 1 in the about example and 2 in the example below.
>>
>>NOI1234-00 Null
>>NOI1234-00 Null
>>NOI1234-00 2003-05-12 00:00:00.000
>>NOI5678-00 2003-04-12 00:00:00.000
>>
>>
>>
>>
>>>>I need a formula to populate a running total variable with a distinct count of a field when another field (on the same record) is not null
>>>>
>>>>Something like
>>>>
>>>>Distinct Count(pocnum) where dreceived is not null
>>>>
>>>>
>>>>Your help is greatly appreciated.
>>>
>>>If you create a count total field, I think it will already ignore nulls.
>>>
>>>BOb