Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: yogeswari on 25 Aug 2016 08:58:04 AM

Title: Identifying duplicate values for different Ccode and Fcode columns
Post by: yogeswari on 25 Aug 2016 08:58:04 AM
Hi,

I have a scenario like this,

Fcode   Ccode   t_num     count -->[calculation: count(t_num) for Fcode]
CH        120      123456     1
EH         121     123456     1
-----------------------------------
Total                                2
-----------------------------------

Both different Fcode and Ccode has same t_num.  Since only 1 t_num has associated to the different code so the total should be 1.  Means duplicate count should not be summed up.


I have tried some logic[by using Distinct] but did not work out.  Please help me to sort out this and it would be great .


thanks,
yogeswari

Text only | Text with Images