Skip to main content

We have been running into a snag with the simple formula of 3 columns adding together and getting off by .01. This normally is not a big deal, but in a contract this can be a very big deal. I have attached the pictures of what I’m talking about and the formula I use.

Welcome to the community, @Tyler_Surrency!


What that means is that one or more of your formula fields are rounding their numbers for display purposes, but the actual numbers are much longer.


Go in & customize your formula fields, click on the “Formatting” tab, and choose a different precision. Then, you will be able to see where the problem lies.


Also, you can just Round your formulas by adding the ROUND() function into your formulas.

Welcome to the community, @Tyler_Surrency!


What that means is that one or more of your formula fields are rounding their numbers for display purposes, but the actual numbers are much longer.


Go in & customize your formula fields, click on the “Formatting” tab, and choose a different precision. Then, you will be able to see where the problem lies.


Also, you can just Round your formulas by adding the ROUND() function into your formulas.


Can you show me in this formula how rounding would work to solve my issue?


Tyler

Can you show me in this formula how rounding would work to solve my issue?


Tyler


You can just wrap the entire formula with the Round function. Something like this:


ROUND(

{Field 1} + {Field 2} + {Field 3} + {Field 4}

,2)

But you may be better served by going back and rounding the other formulas, too, to yield more accuracy.

You can just wrap the entire formula with the Round function. Something like this:


ROUND(

{Field 1} + {Field 2} + {Field 3} + {Field 4}

,2)

But you may be better served by going back and rounding the other formulas, too, to yield more accuracy.


I went back to where it generates the monthly payment automatically. Iput in the formula you wrote me and it worked.


Thank you for your help.


Tyler


I believe you are dancing around this floating point math bug.

Reply


Terms & Conditions