average ignoring empty fields & zero values

Question

hi, in my form i want to calculate average in 40 text fields. fields names are AB-1, AB-2, AB-3, etc up to AB-40. i have found bellow code that really works but only issue is that code not ignoring zero values. so can u pls help me edit bellow code to ignore zero. thanks..

// Initialize variables

var num = 0;

var sum = 0;

// Loop through the input fields

for (var i = 1; i < 5; i++) {

var f = getField("AB-" + i);

if (f.valueAsString) {

// increment the non-blank field counter

num++;

// add the field value to the running total

sum += +f.value;

}

// Calculate the average

if (num) {

event.value = sum / num;

} else {

// All fields are empty, so set to blank

event.value = "";

}

PDF Form Field calculates AVERAGE incorrectly (PDF Forms)

Bernd Alheit · Accepted Answer

Use this:// Initialize variablesvar i, v, num = 0, sum = 0;// Loop through the input fieldsfor (i = 1; i <= 40; i++) { v = +getField("AB-" + i).value; if (v !== 0) { // increment the non-blank/zero field counter num++; // add the field value to the running total sum += v; }}// Calculate the averageif (num) { event.value = sum / num;} else { // All fields are empty, so set to blank event.value = "";}

George_Johnson · Answer

You could change it to something like the following:

// Initialize variables

var i, v, num = 0, sum = 0;

// Loop through the input fields

for (i = 1; i <= 40; i++) {

v = +getField("AB-" + i).value;

if (v !== 0) {

// increment the non-blank/zero field counter

num++;

// add the field value to the running total

sum += +f.value;

}

// Calculate the average

if (num) {

event.value = sum / num;

} else {

// All fields are empty, so set to blank

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