How to Sum Percentage fields

Ok, so I made the following corrections and am still getting this error at the 'bold' location:

SyntaxError: missing ) after argument list 1: at line 2

var dd1 = this.getField(Dropdown1.0).value;
var m1 = this.getField(Max1).value;

If dd1 == "MET-100%" {
Event.value = "m1";
} else {
if dd1 == "NOT MET-0%" {
event.value = .00;
}}

I've tried several things and it won't clear.

Not so simple if you want to suppress the error result when the total of the "A" column is zero and one wants to suppress the "DIV/0!" error and suppress "0" for calculated cells.

Which calculation option did you use?

Have you looked at the JavaScript console for any errors, key combination <CTRL> + "J"?

Are you getting any pop-up errors?

I use the "Custom JavaScript". Just like in Excel division by zero causes an error condition the same happens with calculations in PDF forms, so one needs to adjust the script for this condition.

Portfolio Compute Percentages

has working PDF forms without errors and with errors along with an Excel file

Alright! So I decided to approach it from a different direction. Instead I used a Dropdown list and then tried to use a script to grab the value selected and give either a '.##' or reference another cell with the actual number.  Noting is working and I've tried several.  Once I get this script to work, I can then just use the simple 'Value is the...Sum' option.

Here is one version.

var dd1 = this.getField("Dropdown1.0").value;

var max1 = this.getField("Max%").value;

if (dd1 = “MET-100%”); {

event.value = (".2");

} else {

if (dd1 = “NOT MET-0%”); {

event.value = ".00";

}

Instead of this//

event.value = (".2");

I used this//

event.value = ("max1");

What is the latest script you tried?

If you are going to add a set fields by either the "the field is the sum of the following fields" or the "simplified field notation" the fields in question must have a "Number" or "Percent" format not the "None" or any other option.

You should be aware that the "Format" of a field is the displayed value only. So if a number field has a currency symbol that symbol is only present in the displayed value and the not the actual value of the field. For percentages the actual value of the field is multiplied by 100 and has the "%" post fixed to the displayed value. This lets one use the decimal value of the percentage for mathematical calculations without any addition changes to the fields actual value. If you sum a series of percentage fields that add up to 100% the actual sum of the fields will be 1.00.

If you want to suppress the zeros when using the Percentage format one needs to use scripting to hide the field or dynamically set the format of the field to the Number format or Percentage format as necessary. How to use the special built-in functions for dynamically setting the format for fields was firs documented in the Acrobat JavaScript Reference API and noted in version 6 and 7 documentation.

If you do not use the "Field is the ..." or the "Simplified Field Notation" methods, you need to be careful for field with a null value since for some actions the null value is treated as a zero number and others it is treated as a null string and in JavaScript the "+" operator is the additional operator and the concatenation operator depending upon how JavaScript assume the value to be a number of a string. You need to force the empty or null values to be a the number zero.