Cognos 11 crosstab not giving correct total

[EdwinVD]

 
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

[MFGF]

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

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.

[EdwinVD]

That did not work.

[MFGF]

That 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.