DISTINCT COUNT 1

[renartbrazil]

I am using Distinct Count quite often and I see on issue so far. If there are 10 rows, 5 have different names in them, and 5 are blank then that will give me a Distinct Count of 6 (i want another column to give me the 'Count' of blanks.) How can I deal with the blanks? Can I drag another instance of this needed Requested item in the Request area, put a Count on it , then does anyone know of some code that can help me count the blanks?

 

[strykerhorse]

You could make an if statement like this (i am not using real code):

if(the column that the info is in != null value) {Count Distinct}

the computed item for dealing with blanks would be written in close to the same way:

if(the column that the info is in == null) {Count}

Try those out and I hope I helped. I am running a big Brio job right now or else I would've shown real, tested code in my reply. Take care.

 

[renartbrazil]

that looks like it should work, i will try that, thanks