Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
4.0k views
in Technique[技术] by (71.8m points)

sum - Calculate Profit Loss

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.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
等待大神解答

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

2.1m questions

2.1m answers

60 comments

57.0k users

...