Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Incorrect rounging of 6 digits pecision
Message
De
22/04/2002 16:01:54
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00647785
Message ID:
00647844
Vues:
15
Yuri,

thank you for reply.

In real life, price and quantity fields contain any values up to 6 digits after comma.
I need to round the RESULT of multiplication to two digits.
I cannot round the operands because in this case the result may be incorrect if operands have 6 digits after comma !

How to implement the rounding in this case ?

>OK, I see the problem. It occurs when the sum of the decimals to round exceed 12. Perhaps you my use:
>
>?ROUND( round(t1.price,5)*t2.quantity,2)
>
>
>
>>>The product is 25.425. Why do you expect 25.43? It should be 25.42.
>>
>>Because, when you round 24.425 to two decimals, you get 24.43 (since the first digit dropped is a 5, VFP rounds up). Try it with the ROUND() function.
>>
>>Hilmar.
Andrus
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform