• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

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

New Here ,
Feb 19, 2023 Feb 19, 2023

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

 

TOPICS
PDF forms

Views

1.4K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 19, 2023 Feb 19, 2023

Copy link to clipboard

Copied

Have you read this article:

https://www.pdfscripting.com/public/Value-Entered-Does-Not-Match-Format.cfm

 

 

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 20, 2023 Feb 20, 2023

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?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 20, 2023 Feb 20, 2023

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Feb 20, 2023 Feb 20, 2023

Copy link to clipboard

Copied

LATEST

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. 

 

 

 

 

Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines