Rounding Error After Summation

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?

Developer Tools

Common Use Cases

Accepted answers

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

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

All comments

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703