distinct count problem

[rickxx]

using 'distinct count' in a count of data in a report that combines 3 excel worksheets. i look at the details and count manually and the count is off by one in two of the columns. ideas? thanks. rick

 

[beltmanjr]

Please provide a lot more info for anyone to help you resolve this.

I mean this could range from how you are counting to how you're importing the data.

 

[PatriciaObreja]

I think that when you manually distinct count, you cannot see some extra spaces that maybe some records have, that could seem identical to you.

-------------------------------------------------------------------------------------------------------------------------
"Now I can look at you in peace; I don't eat you any more." Franz Kafka, while admiring fish in an aquarium

 

[lbass]

I'm betting you are doing a distinctcount on a conditional formula--which will count the default value as well for records that don't meet your criteria. Please show us the content of the formula, if this is the case.

-LB

 

[rickxx]

wow! thanks for the quick responses. the file is at work so i'll try and upload tomorrow. this is my first question on the forum so i appreciate your help.

rick

 

[lbass]

Please just respond to the questions as a first step.

-LB

 

[rickxx]

greetings. figured out the answer to my problem. it had to do with null values. i went to file/ report options, and unchecked "convert database null values to default" and now my distinct counts are correct.