Skip to main content
devonc47393610
Participant
Jun 25, 2019 5:36 PM UTC
Question

The value entered does not match the format of the field

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 is closed to new replies. Start a new post to keep the conversation going.

4 replies

gkaiseril
Inspiring
Jun 25, 2019 9:31 PM UTC

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.

Translate
try67
Community Expert
try67Community Expert
Community Expert
Jun 25, 2019 9:38 PM UTC

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

Translate
gkaiseril
Inspiring
Jun 25, 2019 9:58 PM UTC

I usually see "NaN".

Translate
try67
Community Expert
try67Community Expert
Community Expert
Jun 25, 2019 8:12 PM UTC

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.

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