Rounding Error After Summation

[MistyClark05]

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?

[kylemhabe · Accepted solution]

Try using the formula tool with the formula: Round([Field1], .02).

Then convert the output of that formula to fixed decimal 19.2.

[MistyClark05]

That took care of it, thank you!

[MistyClark05]

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??) 

[kylemhabe]

Oops, try this instead: Round([Field1], .0001)