Thanks fo rthe reply. I tried it earlier it is working fine but my question is .
if i have a record like this
jobnumber, cost, BaseToSEKRate, AverageRate , type
Will it eliminate only the record 1,600,5,5,A since we are already having 1,600,5,5,A(in this case o/p will be 1200)
1,600,5,5,A and give o/p 600