Participating Frequently

Answered

The value entered does not match the format of the field

Forum|Forum|4 years ago
March 23, 2021
4 replies
14600 views

Please help! I am fairly new with using adobe and creating javascript equations. I have run into the error that many new user have, the dreaded "The value entered does not match the format of the field" pop-up. This only occurs when the value answer is 0...

I am creating a till balance form for a retail company, so having that 0 value show is important and fairly frequent, as you want the till to show 0 variance.

Here are the columns Cash(Counted) = AMCash
Cash on Shift Report = AMPOSCash

For the Cash +/- I have a Simplified Field Notation set as AMCash-AMPOSCash
The format is Number to the second decimal point, which I need since we are talking money.
It does the math just fine, but I meet an error when the total is 0 for that column.

I have spent so long on trying to get this to function properly. Please help me if you can!!! Thank you!

This topic has been closed for replies.

Correct answer try67

Really not sure how you both are getting different error messages than me. This is when I am out of preview/edit mode and accessing the form like someone with standard access.

@try67 @Bernd Alheit

OK, now that you've (finally) provided a concrete example I was able to reproduce it.

This is happening due to a rounding issue. The value of "AMCash" is not really 91.58, but 91.58000000000001. And when you subtract 91.58 from that you get this value in "AM Cash Variance": 1.4210854715202004e-14

This value can't be shown by the Number format, which causes the error. You would have seen all of this if you had just removed the Number format from your fields.

Anyway, the solution is to round the results of your calculations. To do so you would need to use a script.

For example, for AMCash you can use the following:

var v1 = Number(this.getField("BTotal").valueAsString);
var v2 = Number(this.getField("ATotal").valueAsString);
event.value = (v1-v2).toFixed(2);

Bernd Alheit

Community Expert

There is no calculation at the field.

IndiErstAuthor

Participating Frequently

I reattached... here it is again, not sure why it isn't showing but this definitely has the calculation.

Daily_Sales_Report_v2021-5.pdf

IndiErstAuthor

Participating Frequently

thank you for looking.

Thom Parker

Community Expert

Here is an article on this very topic. It includes possible fixes:

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

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

IndiErstAuthor

Participating Frequently

Thank you- I've been looking at this but I'm afraid I don't quite have the javascript knowledge to create my own customized scripting. 😞

IndiErstAuthor

Participating Frequently

I've seen people give formulas like the below to solve the issue....

var Volume = this.getField("Volume").value;
var Hours = this.getField("Hours").value;
var Maximum = this.getField("Maximum").value;

if (Volume.valueAsString !=""){event.value = Volume/Hours/Maximum}
if (Hours.valueAsString !="")
{event.value = Volume/Hours/Maximum}
if (Maximum.valueAsString !="") {event.value = Volume/Hours/Maximum}

event.value = Volume/Hours/Maximum;

but I truly don't understand these and need some help...

try67

Community Expert

How is this related to your original question?

IndiErstAuthor

Participating Frequently

It's related because I've seen formulas like this example in other threads to fix the issue I am having.

try67

Community Expert

This should not be happening. Can you share the file with us?

What exact values are you entering into both fields?

IndiErstAuthor

Participating Frequently

Thanks for willing to help me!

The cash(counted) column adds up the total of another portion of the form. The cash on shift report column is cash sales for the day, so the values input always vary, but should match.

For example:
Cash(Counted) $372.45 - Cash on Shift Report, $372.45 = 0.00

Here is the form.

Daily_Sales_Report_v2021-5.pdf

IndiErstAuthor

Participating Frequently

Also, the cash(counted) column equation works well, so I just want to express that this is not the issue. I am running into this error multiple times on this form, but only when an equations answer is 0.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded