alvin101 — 2011-04-18T14:04:08-04:00 — #1
I have a statement (below) that gives me a column (price) that shows decimal place of .... I would like to round the result to 2 decimal place. But I can not seem to get it to work. Tried everthing I could find about the ROUND () function.
What is the best way to get this result?
Where in this statement would I put ROUND (,2)?
, inventory.full_price * .12 + inventory.full_price * 7.69 AS 'price'
ON inventory.sku = inventory_history.sku
WHERE inventory_history.store_id = 4
ORDER BY inventory.sku ASC
starlion — 2011-04-18T14:07:26-04:00 — #2
that's a very odd select math you're doing there, but
ROUND(inventory.full_price * .12 + inventory.full_price * 7.69,2) AS 'price'
r937 — 2011-04-18T14:32:09-04:00 — #3
ROUND(inventory.full_price * 7.81 , 2) AS price
system — 2011-04-18T14:41:09-04:00 — #4
:tdown: What's with the round-about answers...?
alvin101 — 2011-04-18T14:43:10-04:00 — #5
You just hit on something, .12 being tax, and 7.69 being exchange rate. In the end I will need to go to a different table to get them...