Need help with calculation

I have this problem giving me gray hair. So I have customer no, sales, cost and cost of sales %. The cost of sales % is correct for each customer no, but the total is wrong. I would like it to be ...