COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gats1527 on 08 Jan 2018 09:09:06 AM

Title: Summary Totals not calculating correctly
Post by: gats1527 on 08 Jan 2018 09:09:06 AM
We have a report that details the individual expense amounts and then the total report amount of a single row but now we have a summary for the total report amount per employee but if there were 2 lines on a report, it is adding the total report amount 2 times for the summary total line.  See attached where the highlighted summary has the 6.40 report amount being captured twice.

Thank you
Tom
Title: Re: Summary Totals not calculating correctly
Post by: hespora on 08 Jan 2018 09:16:08 AM
Have to think about the issue, but please: Edit your screenshot. Real names in there? C'mon...
Title: Re: Summary Totals not calculating correctly
Post by: BigChris on 08 Jan 2018 09:40:18 AM
Couldn't you do the total on the Approved Amount column instead? Alternatively, you might need to play with the solve order