Does anyone have a good idea how to handle a problem like this?
I am writing rather long tables of financial data on asps; the financial data elements are stored in my database as "money" data type elements which has 4 numbers to the right of the decimal point.
When I display the data on my page, I am using formatcurrency(data,2). The problem is - i get rounding errors when I total up the numbers at the bottom of the page. I accumulate the totals using the data before the formatcurrency statement is applied.
Thanks if anyone has ideas about this.
I am writing rather long tables of financial data on asps; the financial data elements are stored in my database as "money" data type elements which has 4 numbers to the right of the decimal point.
When I display the data on my page, I am using formatcurrency(data,2). The problem is - i get rounding errors when I total up the numbers at the bottom of the page. I accumulate the totals using the data before the formatcurrency statement is applied.
Thanks if anyone has ideas about this.