Rounding Issues

S

Santi

Hi, I noticed that every time I dive, add or multiply a number in euro the
answer doesn' t Maatch the euro number. Does anyone know how to eliminate
this ongoing issue i'm having?

Here is an example to better explain my problem:

let's say I have a bottle of rum that cost 4.50€ and let's says there are 12
bottles in tha case. If I want to find out what the case cost is if I do 4.50
x 12 I would get the case cost, but when dealing with euros the final case
cost once I multiply doesn't reflect the bottle cost once I divide my answer
again. I would get something like 4.53 or similar
 
J

John W. Vinson

Hi, I noticed that every time I dive, add or multiply a number in euro the
answer doesn' t Maatch the euro number. Does anyone know how to eliminate
this ongoing issue i'm having?

Here is an example to better explain my problem:

let's say I have a bottle of rum that cost 4.50€ and let's says there are 12
bottles in tha case. If I want to find out what the case cost is if I do 4.50
x 12 I would get the case cost, but when dealing with euros the final case
cost once I multiply doesn't reflect the bottle cost once I divide my answer
again. I would get something like 4.53 or similar

The Currency datatype has four and exactly four decimal places, so you could
get roundoff error, or you could have some digits (there but undisplayed)
after the first two decimals. I couldn't get your example to cause an error:

?ccur(4.5) * 12
54
?(ccur(4.5) * 12)/12
4.5

but that kind of roundoff or hidden decimals certainly can happen.

If you could post the actual sequence of operations and the resulting error
someone should be able to suggest a getaround.
 
D

De Jager

Santi said:
Hi, I noticed that every time I dive, add or multiply a number in euro
the
answer doesn' t Maatch the euro number. Does anyone know how to eliminate
this ongoing issue i'm having?

Here is an example to better explain my problem:

let's say I have a bottle of rum that cost 4.50€ and let's says there are
12
bottles in tha case. If I want to find out what the case cost is if I do
4.50
x 12 I would get the case cost, but when dealing with euros the final case
cost once I multiply doesn't reflect the bottle cost once I divide my
answer
again. I would get something like 4.53 or similar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top