See attached pdf please. Am using Cognos 11. My crosstab should say 100.00% in bottom right corner. Otherwise it works fine. Properties of bottom right cell are in pdf file.
The 3 bottom % amounts are a query calculation. They just do not add up as they should. It is taking the last amount (9.95%) and using that in bottom right corner. Why would that be ? Thank you. Edwin
Quote from: EdwinVD on 08 Aug 2024 07:04:59 AMSee attached pdf please. Am using Cognos 11. My crosstab should say 100.00% in bottom right corner. Otherwise it works fine. Properties of bottom right cell are in pdf file.
The 3 bottom % amounts are a query calculation. They just do not add up as they should. It is taking the last amount (9.95%) and using that in bottom right corner. Why would that be ? Thank you. Edwin
Hi,
Try changing the Summary Aggregation property of the calculated item to "Calculated" rather than "Total". Does that give you the correct result?
Cheers!
MF.
That did not work.
Quote from: EdwinVD on 08 Aug 2024 09:40:41 AMThat did not work.
Here's a previous post from someone with similar issues. Try following the steps I suggested, and see if that helps?
https://www.cognoise.com/index.php/topic,36133.msg119133.html#msg119133
Cheers!
MF.