Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
Have you read this article:
https://www.pdfscripting.com/public/Value-Entered-Does-Not-Match-Format.cfm
Copy link to clipboard
Copied
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?
Copy link to clipboard
Copied
Interestingly, if change the value of A (or 2022 Available) to 4287 or 4289, there is no error. But it errors again if you change it back to 4288
Copy link to clipboard
Copied
Remove all formatting so you can see the real values being calculated. This also ensures the error popup is associated with the field you think it is.