Skip to main content
D
devonc47393610
Participant
June 25, 2019
Question

The value entered does not match the format of the field

  • June 25, 2019
  • 2 replies
  • 547 views

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?

This topic has been closed for replies.

2 replies

G
gkaiseril
Inspiring
June 25, 2019

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
Community Expert
try67Community Expert
Community Expert
June 25, 2019

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

G
gkaiseril
Inspiring
June 25, 2019

I usually see "NaN".

try67
Community Expert
try67Community Expert
Community Expert
June 25, 2019

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices