5 ms·
A quick search reveals that the highest precision should be used for storage and calculations, and rounding just for presentation. So it shouldn't matter what r
by byoung2 10y ago
A quick search reveals that the highest precision should be used for storage and calculations, and rounding just for presentation. So it shouldn't matter what rounding rule you use for display purposes.
I did find this explanation of Euro rounding rules: http://www.sysmod.com/eurofaq.htm#ROUNDING http://www.sysmod.com/eurofaq.htm#ROUNDING
- malux85 10y agoClose, but wrong, You should store it highest precision, but calculate on a configurable rounding scheme. Some accounting systems always round line items to 2 decimal places, some always round with 3. Some round tax to 3 DP because it's a regulatory requirement. You would think it doesn't matter much, but in many places it does -- especially businesses that sell many, small priced items, and have invoices that are thousands of lines long .. 2dp/3dp rounding (and rounding on discount % calculations too) can mean that invoices are 10's or hundreds of dollars out. Store high precision, calculations are configurable.