Thanks alot ChrisM@Work,

My mistake unit cost was 0 on those rows.

Thanks ChrisM@Work for the help, it removed the duplicates as i had asked but the total cost for the added column displayed value for only dollars(id for dollar is 3...