Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Inaccurate results when using large numbers
In our VFP application to support Unit Trusts (Mutual Funds) we have the occassional need to record reasonably large transactions and we note that sometimes VFP appears to get it wrong in the sixth decimal place. (We are required to record 6 decimal places for some clients.)
Have other people experienced this problem and are there any known work arounds other than the obvious one of not using the VFP ROUND() function.
For example:
Buy amount = $800,000,000.00
Unit Price = 0.938208
Units issued = 800,000,000.00 / 0.938208 = 852,689,382.311811
In VFP command window 800000000 / 0.9382080 = 852,689,382.311811
but ROUND(800000000 / 0.9382080,6) = 852,689,382.311812
and ROUND(800000000 / 0.9382080,7) = 852,689,382.3118114
In Excel 800000000 / 0.9382080 = 852,689,382.311811
and ROUND(800000000 / 0.9382080,6) = 852,689,382.311811
Any suggestions would be much appreciated.
Thanks
Paul Dorrington
(Melbourne, Australia)
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