rounded Numbers

Alexis_Colon_Lugo · August 3, 2013, 5:04am

What is the best variable to calculation to minimize rounded numbers?

Using PostgreSQL

Jeremy_Cowgar · August 3, 2013, 2:06pm

I’m not sure what you are asking, can you state the question in a different form?

Alexis_Colon_Lugo · August 3, 2013, 4:55pm

to get a closer results when making divisions and the results have cents
Examples
11.99*6.0 %= 0.65945
i like to be =0.66

DaveS · August 3, 2013, 4:57pm

x=11.990.06
x=ceil(x100)/100

Alexis_Colon_Lugo · August 3, 2013, 5:05pm

thanks

Jeremy_Cowgar · August 3, 2013, 5:15pm

Rick_Araujo · August 3, 2013, 6:00pm

11.99*6.56=78.6544

Do you want 78.65 or 78.66 ?

If the first, change Ceil by Round in Dave’s solution.

Rick_Araujo · August 3, 2013, 6:03pm

Are you talking about calculation on which side? SQL or Xojo? For PostgreSQL there is the direct Round(n, 2)

Rick_Araujo · August 3, 2013, 6:31pm

Jeremy, Currency data type holds 4 decimals. Great for many aspects, but if the intention is rounding on 2 digits, he needs extra steps.