Identifying duplicate values for different Ccode and Fcode columns

[yogeswari]

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