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

List Report Where Two of My Columns Are Not Summing Correctly

Started by pdaprem, 19 Oct 2011 01:04:34 PM

Previous topic - Next topic

pdaprem

I have a List report with 11 columns, 6 of which I need to aggregate the totals at the summary level.  Two of my columns has the correct data values in all rows but they do not sum correctly. The two data fields which do not correctly sum are derived in the FM model as count (distinct data name) where the data fields being counted , employee number and offering number, are both character type data fields. The resultant query items are both Int32 with Regular Aggregate and Semi-Aggregate set to SUM.

The common element for these two query items is that both are derived using the count distinct from the same DB2 relational database.

Any suggestions on how to get these two data fields to sum correctly will be deeply appreciated.

This has been resolved. The two data columns with the count distinct values are indeed summing correctly.
Thanks!