Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report losing one hundredth
Message
De
24/01/2007 10:27:48
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01188069
Message ID:
01188684
Vues:
19
This message has been marked as a message which has helped to the initial question of the thread.
>>Not a bug, it's a limitation of the IEEE binary representation of numbers. The report truncates instead of rounding, which is not really serious enough to be considered a bug.
>>
>>At 14 digits, you're really close to the limit of 15.5 significant digits, which is the capacity of IEEE standard. If you are subtracting numbers which are longer than that, the result may lose lower digits (you get zeros there) even though the result is shorter than the limit.
>>
>>Is the inflation that bad over there?
>
>No the inflation is low. Its the balance of my account :)
>Actually its sort of a yearly turnover of the district where i live.
>So i geather i have to comb thru all my reports and change money/100 to round(money/100,2)

Yes... and I can only offer you a shorter way to do it:
use my.frx
browse for "/100"$expr
Maybe even
replace expr with "round("+expr+",2)" for "/100" $ expr ;
   and atc("round", expr)=0
Do I need to say "backup first"?

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform