Can a calculated field ignore fields that do not currently contain a numeric value?

Question

I am creating a form in Adobe Acrobat and I need to average a column of numbers. The problem is, not all rows of that column will always have a numeric value but the basic calculation function includes the row in the average anyway.

Here is a simplified version of my table:

Criteria	Rating
1.1	3
1.2	4
1.3
1.4	2
1.5	3

The average of the four rows that contain a value is 3. But the calculate field function counts row 1.3 as a zero, even though no zero is present and generates an average value of 2.4.

I don't know Javascript very well. Is there a custom calculation script that can help me with this?

Joel Geraci · Accepted Answer

Name the fields in the "Rating" column using hierarchical field names like "rating.1","rating.2", "rating.3" etc. then add the following script to the calculation of the average result field.

var aRatings = [];

var nTotal = 0;

var aRatingFields = this.getField("rating").getArray();

for (var i=0; i < aRatingFields.length; i++) {

var value = aRatingFields.value

if (value != "") {

aRatings.push(value);

nTotal += value;

}

event.value = nTotal/aRatings.length

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