Adding currency problems

[Jx4]

Hi there,

I am currently having trouble with some issues with adding Currency values. I have one column with values of transactions and the other column has a running total. It works great however, because the numbers are rounded (currency), they don't look like they add up right eventhough they do.

For instance: if you add $2,632.1743 and $8.6528, you get $2,640.8271. The problem is when the currency rounds these amounts you get: $2,632.17 and $8.65 equals $2,640.83. So eventhough they are adding correctly, they don't appear too.

Is there a way of making all the numbers in my database only use 2 decimals places thoughout the whole database or something to make everything "appear" to be adding up properly?

Thanks again.

[pks00]

are these fields variables u are using or values read from tables. if the latter then u could try specifing this in the table design

the field in question, u could set the Decimal Places to be 2

[Lysander]

Hi there,

I am currently having trouble with some issues with adding Currency values. I have one column with values of transactions and the other column has a running total. It works great however, because the numbers are rounded (currency), they don't look like they add up right eventhough they do.

For instance: if you add $2,632.1743 and $8.6528, you get $2,640.8271. The problem is when the currency rounds these amounts you get: $2,632.17 and $8.65 equals $2,640.83. So eventhough they are adding correctly, they don't appear too.

Is there a way of making all the numbers in my database only use 2 decimals places thoughout the whole database or something to make everything "appear" to be adding up properly?

Thanks again.

One solution is to use integers and store all your currency values as cents (or pennies or whatever) and divide by 100 to display the results. That way, no rounding errors.

[Jx4]

Thanks for the suggestions!! I appreciate the help!