|Subject:||Re: The difference between currency and number is..
|Date:||Mon, 11 Jun 2018 15:10:31 -0400
|From:||"Steven Green" <email@example.com>
> It smells like number and currency use different calculation/rounding
Myrtle Beach, South Carolina, USA
Collectibles and Memorabilia
Vintage Lego Sets and Parts
- and Paradox support, too
"Bernie van't Hof" wrote in message
What are the results of each calc before and after rounding, prior to
calculating the difference?
It smells like number and currency use different calculation/rounding rules.
And if these rules changed version to version, grrrrr....
Sometimes its better to roll your own rounding function. At least then you
always know exactly what the outcome will be.
On 11/6/18 10:07 pm, Steven Green wrote:
> paradox DOS used "banker's rounding".. round to the even side.. 5.5 rounds
> up to 6, but 4.5 rounds down to 4.. in theory, with large groups of
> numbers, that's more accurate, but it's not "normal"
> from the beginning, paradox WIN used "banker's rounding, too, but I don't
> remember where it stopped.. only 16 bit BDE ??
> Steven Green
> Myrtle Beach, South Carolina, USA
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too
> "Bernie van't Hof" wrote in message
> Careful which rounding you use, and when:
> 5.5 + 7.5 + 6.5 + 9.5 = 29
> After rounding: 6 + 8 + 7 + 10 = 31
> 9*42.45 = 292.905000000000000 (floating point)
> Does x.round(292.905) become 292.90, or 292.91?
> Exactly what are the rounding rules of p7/9.
> Do currency and data type use different rule?
> And finally..
> A farmer counted 87 cows in the field, but when he rounded them up he had
> - Bernie
> On 9/6/18 3:39 am, Steven Green wrote:
>> correct.. welcome to wonderful world of paradox rounding inconsistencies
>> Steven Green
>> Myrtle Beach, South Carolina, USA
>> Collectibles and Memorabilia
>> Vintage Lego Sets and Parts
>> - and Paradox support, too
>> "GŁnter" wrote in message news:firstname.lastname@example.org...
>> Try it out, best with Watches,
>> n number
>> c currency
>> Seems that currency emulate a old Dek-Table-Add-Maschine, with only 2
>> decimal places