Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

distinct count problem

Status
Not open for further replies.

rickxx

Technical User
Nov 21, 2007
14
US
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
 
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.
 
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.

-LB
 
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
 
Please just respond to the questions as a first step.

-LB
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top