Skip to main content
Participant
February 20, 2023
Question

"The value entered does not match the format of the field" with no division

  • February 20, 2023
  • 1 reply
  • 1981 views

I am a lawyer trying to make a contract that auto populates off a cover sheet.  I am not dividing by zero, yet I am getting the "The value entered does not match the format of the field []" error on fields with simple notation like this (I do not know java, use value dropdown or simplified field notation):

 

Input = A, B, C, D

Dropdown = E [value for choice E1 is 0.9 / choice E2 is 0.85]

Calculated = 1 [Product (x) of A, E], 2 [minimum of 1, B], 3 [notation of ((A+C)*E)-2], 4 [minimum of 3, D], 5 [notation of (((A+C)*E)-2)-4], 6 [notation of 5/"12"]

 

If I input the following values A=4288, B=4769, C=0, D=0, E=E1, by the time I enter D (I usually do the dropdown first), I get the following errors:

"The value entered does not match the format of the field [ 3 ]"...

Immediately followed by

"The value entered does not match the format of the field [ 5 ]"...

Immediately followed by

"The value entered does not match the format of the field [ 6 ]", plus...

It gives me the same (but wrong) value for 3 and 5, usually the value 1.

And yes, I made sure the field calculation order goes 1, 2, 3, 4, 5, 6....

 

Any help would be appreciated.  Thanks to everyone in advance!

 

I added an example of the problem, for it, input the following values 2022 Available=4288, 2022 Anticipated=4769, 2021 Available=0, 2021 Anticipated=0, Client Type (First Box)=Standard

 

This topic has been closed for replies.

1 reply

Thom Parker
Community Expert
Community Expert
February 20, 2023
Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
Participant
February 20, 2023

I just read it, but I am a little confused.  I am not dividing by 0 and should not have any NaN output fields.  The only division I make for field 6, and that field 5 divided by the number 12.  What am I missing?