Totals Summing up incorrectly

[barrysaab]

I have two table A and B ,in Table B the value for example 1 is repeating 4 times. I have given inner join between the two tables. The Problem is in report when I see the totals it is adding up all 1 to 4(1+1+1+1).But I want the total only for distinct value.Could gurus please help.Thanks

[blom0344]

Overcounting in some cases can be corrected by tricks like:  max([somevalue] for [somekey])  or by setting the proper determinant.  In header-detail scenario's Cognos often makes the right correction when you set an unique determinant on the header table. There is a lenghty discussion somewhere on the forum:

http://www.cognoise.com/community/index.php?topic=17280.0