Calculations in Adobe Acrobat

Is it "N/A" or "N / A"?

Can you share (part of) this form?

Place this script as a calculation script in the field that display the result:

var total = 0;
for (var i = 0; i < this.numFields; i++) {
var oFld = this.getField(this.getNthFieldName(i));
if ((oFld.type == "combobox") && (oFld.valueAsString == "N/A")) {total++;}
}

event.value = total;

Hi,
You need to use a "for loop" operation.

For this to work you need to make sure that allof the dropdown field names are prefixed; the prefixed part of the dropdown fieldname is used to perform the looping function correctly.

In your case, lets say that you have 3 columns of seven rows each, and each dropdown fieldname will be prefixed as "dropdown1" for the first 7 rows , "dropdown2" second set of rows, and "dropdown3 for the third set of rows.

The line of javascript code below is an example of how it may be used to calculate total number of dropdowns with "N/A" as the selected item.:

NOTE: I have not tested this successfully on my end but you can give it a try.

var v = "N/A"; 
var total = 0; 
for (var i=1; i<=7; i++) { 
if (this.getField("Dropdown1"+i).valueAsString==v) total++; 

} 
event.value = total;