How to resolve "“The value entered does not match the format of the field [x]”?

Question

I have a PDF form with several computed fields:Field A (How many people?)-          Input field-          Format : Numeric (whole number)Field B (How many days?)-          Input field-          Format: Numeric (1 decimal place)Field C (Total Meal Money)-          Computed (Field A*Field B*30)-          Format: $ with 2 decimal placesField D (Meal / Person)-          Computed (Field C/Field A)-          Format: $ with 2 decimal placesField E (Fuel Money)-          Input field-          Format: $ with 2 decimal placesField F (Emergency Money)-          Input field-          Format: $ with 2 decimal placesField G (Total Cash Requested)-          Computed (Field C+Field E+Field F)-          Format: $ with 2 decimal placesI also have created a Reset Form button that runs the following JAVA script:if(4==app.alert("This action will clear all input fields in this form.
Do you want to continue?",1,2))this.resetForm()My issue is that I am getting a Warning which says…“The value entered does not match the format of the field ”a)      each time I click the Reset Form buttonb)      when Field A is zero (0) and try to change the value of Field B, Field E or Field FI noticed that this warning happened when the value of Field A is zero (0).

try67 · Accepted Answer

A very similar question was just answered here: When entering data into text field I get this message - “The value entered does not match the format of the field [CostP…

jessica5EB6 · Answer

These solutions work for me to remove the error from the divide by "0", but now the calculation is not calculating properly.

Below is my current calculation script. ultimately it is adding "1" to the final output and not completing the "*100" step.

For example, if the current rate is 25 and the new rate is 26, it was calculating the percentage increase correctly at 4.00%, then I added the suggested solution in italics, and the new result of the calculation is now 1.04. How do I get it to go back to calculating correctly to 4.00% without the divide by 0 error?

event.value = ( this.getField("New Hourly Rate").value - this.getField("Current Hourly Rate").value ) / ( this.getField("Current Hourly Rate").value ) * 100;
var nPeople = this.getField("Current Hourly Rate").value;
if(nPeople != 0) {
event.value = this.getField("New Hourly Rate").value / nPeople;
} else {
event.value = "";
}

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