COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: fkli222 on 02 Apr 2019 11:13:39 AM

Title: Percentages at subtotal level is adding up instead of calculating
Post by: fkli222 on 02 Apr 2019 11:13:39 AM
My percentages keeps adding up instead of recalculating. I have tried removing the totals and using default summary instead. Also tried changing the summary and detail aggregation level for everything to calculated but still no luck. This normally works for me but not sure why, any one have any ideas?

Thank you!
Title: Re: Percentages at subtotal level is adding up instead of calculating
Post by: oscarca on 04 Apr 2019 01:39:21 PM
How does your subtotal query look like (query expression ?)