sum - Calculate Profit Loss

Question

I cannot grasp this. I am trying to determine profit/loss percentage. My table is: SOLD_PRICE | QTY_ SOLD | PRODUCT_COST | QTY_PURCHASED

SOLD_PRICE is 170.00, QTY_SOLD is 1, PRODUCT_COST is 43.00, QTY_PURCHASED is 2

(SUM(sold_price) * (qty_sold)) - (SUM(product_cost) * (qty_purchased)) / (SUM(product_cost) * (qty_purchased)) as 'totalpct' This is GROUPED BY UPC code

I get a value of 169, but it should be 170.00 * 1 = 170.00 - 86.00 = 84.00 / 86.00 = 0.976

Please help, it is driving me mad and cannot grasp where 169 is coming from.

Answer 1

等待大神解答