Information générale
Titre:
Precise Calculation
I need to convert from local to foreign currency and vice vesa.
The problem I faced was it wouldn't be accurate when converting the second
time.
First, I need to convert from foreign to local and store the result(in 2
dec. places)
into the table.
The second time I want to convert from local(from table) to foreign and
display on
screen, but the result will not be the same as the original value.
Eg:
- where exchange rate 99.9999 format
1st round - foreign $10.00 --> local $5.55 (store into table
with ROUND( ) )
2nd round - local $5.55 --> foreign $9.99 (should be $10.00
originally)
Any better ways to get more accurate results? Pls advise, thanks.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement