Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Why & What is the Difference?

Topic Labels: Base design
Solved
Jump to Solution
1342 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Abraham_Bochner
8 - Airtable Astronomer
8 - Airtable Astronomer

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

Screenshot_48

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 !!!

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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)

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

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)