Total Sum Expression

[khaycock]

I am having a weird problem with the sum of many freight charges where the total sum of DEL_GBP_FREIGHT should be 20.00 as there is only 1 lot of 20.00 in the set of data, but the expression is calculation 40 and I have no idea why!!

This might be something silly but I really can't figure it out. I think its having an effect on another expression too.

Any ideas?             

[florentina_doga]

Commenting on fields does not remove duplicates

[khaycock]

Ahhhh that's amazing thank you!!

Do you think you could help me with getting a total of the split charges as well? I'm basically trying to SUM the total UPS charge which is £19.64 per day of deliveries. I have the split sum working in the pivot table fine but now i need to sum those 19.64s to create a variance against the other freight charge for the Total Freight Charge table.

I've attached another qvw with the expression in it...