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!