>>Do all your calculations with the same precision.
>>
>>Vlad
>>
>>>I have a financial type app and parts of it use calculations that
>>>cause values in fractional cents. For example, the result of one
>>>calculation may cause a value of 3.5835 while another will be
>>>3.5888. This can cause rounding errors when reporting the data
>>>in dollars and cents.
>>>
>>>How do things like SBT accounting systems handle these issues?
>
>This is one of the reasons there is the 'Currency' type data - it defaults to 4 decimal places so that this kind of rounding problem is eliminated.
>
>Barbara
Ok, so how do I do all calcs with the same precision? The currency
data type always returns things out to 4 decimals, but I have not
seen a fractional penny as of late. How do I keep all answers to be
at no more precision than pennies - with ROUND()? Why do I want
currency to be at four digits? Can I change it to only 2 to eliminate
the issue?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only