The value entered does not match the format of the field

[devonc47393610]

I keep getting an error ... The value entered does not match the format of the field [Ten Pay].  The simplified field notation I am using is (BalDue / #Mo) + Disc$.  Can someone help correct this error?

[try67]

This happens when you try to divide by zero. Search the forums for "division by zero" and you'll find the code to solve it.

[gkaiseril]

You can also set the format of the field to "None" and see the result of the calculation without any formatting. Sometimes using the custom JavaScript calculation can help you debug the issue.

[try67]

If you do that the value it will display will be "Infinity", most likely.

[gkaiseril]

I usually see "NaN".