Why is this this Balance Column not equal to Zero 0.00?

My Formula is {Net Bill Amount}-{Total Paid}

How can I build the Formula that is should say 0.00 , I need it as a 0.00 !!!

Why is this this Balance Column not equal to Zero 0.00?

My Formula is {Net Bill Amount}-{Total Paid}

How can I build the Formula that is should say 0.00 , I need it as a 0.00 !!!

You have run into a floating point error that is common to many computer systems.

While there are many different solutions, I suggest having the formula round the difference to two decimal places.

```
ROUND({Net Bill Amount} - {Total Paid}, 2)
```

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.