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
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 (http://www.cognoise.com/community/index.php?topic=17280.0)