Hi, I'm doing a calculation with a tax and I'm having an issue with rounding. The amount is $16.50 and the tax is 5%. When calculated, as you see below, it comes to 17.325, which should round up to 17.33. But as you can see below, it goes to 17.32. Any ideas?
mysql> select 16.5+(16.50.05);
+------------------+
| 16.5+(16.50.05) |
+------------------+
| 17.32 |
+------------------+
1 row in set (0.00 sec)
mysql> select 16.5+(16.50.050);
+-------------------+
| 16.5+(16.50.050) |
+-------------------+
| 17.325 |
+-------------------+
1 row in set (0.00 sec)
Thanks!
Mike
