Return count where field is blank

[#1]

I need to do a unique count of UserNames where the Firm field is blank

I tried this, but it didn't work

=COUNT(DISTINCT {$<Firm-={'*'}>}UserName)

any ideas?

[rwunderlich]

I think this will handle both blanks and nulls:

COUNT(DISTINCT {$<UserName={"=len(trim(Firm))=0"}>}UserName)

-Rob

http://masterssummit.com

http://robwunderlich.com

[#3]

Thanks Jacob. Would I have to adapt my expression? Or would the null values be counted automatically?

[#4]

I think you could use NullCount(distinct UserName), but you could also try Rob's solutions. They might be simpler.