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
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
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.
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.