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