If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Adding a field causes results to double counting

Started by que1983, 29 Mar 2016 01:32:39 PM

Previous topic - Next topic

que1983

I have queries as follows:
retail
wholesale
report query1

retail and wholesale have a cardinality relationship to report query1 1:n  and 1:1.
I added a field to retail query called descr_code.  Because several descr code can be associated with one record, it causes double counting when I run the report.  In properties I did a count distinct however I still get duplicates when I run the report.  Is there a way to avoid the duplicates.  Will I need another query???