Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 11, 2020 08:56 AM
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 !!!
Solved! Go to Solution.
May 11, 2020 10:57 AM
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