I am getting a rounding error when I sum two amounts together using the formula tool. Both amounts are set as a fixed decimal type 19.4, with the output column 19.2. It is calculating -13.395 + 0 = -13.39, and I need it to round this figure up. Any suggestions?
Solved! Go to Solution.
Try using the formula tool with the formula: Round([Field1], .02).
Then convert the output of that formula to fixed decimal 19.2.
That took care of it, thank you!
Check that, this did not work.
One of my results rounded from -13.395 to -13.40 (Perfect!) but the other one rounded from 65.505 to 65.52 (Why??)
Oops, try this instead: Round([Field1], .0001)