Skip to main content
robertl78874585
robertl78874585
Participant
May 19, 2023
Answered

Calculate Average and ignore zero/blank.

  • May 19, 2023
  • 2 replies
  • 895 views

So I should start by saying that I've tried to find and/or adapt code within the discussion boards for the past couple of days. However, I keep getting syntax errors, or the code doesn't work. 

Anyways, I have a form with 6 boxes for scores. How can I code the 7th box to be the average of the 6 boxes and ignore blanks or zeros? 

 

    This topic has been closed for replies.
    Correct answer Nesa Nurani

    EDITED:

    As 'Custom calculation script' of '2g' field, use this:

     

    var total = 0;
var avg = 0;
for(var i=1; i<=6; i++){
if(this.getField("2e"+i).valueAsString != "" && Number(this.getField("2e"+i).valueAsString) != 0){
total += Number(this.getField("2e"+i).valueAsString);
avg++;}}

if(avg != 0)
event.value = total/avg;
else
event.value = "";

     

     

    2 replies

    Nesa Nurani
    Community Expert
    Nesa NuraniCommunity ExpertCorrect answer
    Community Expert
    May 19, 2023

    EDITED:

    As 'Custom calculation script' of '2g' field, use this:

     

    var total = 0;
var avg = 0;
for(var i=1; i<=6; i++){
if(this.getField("2e"+i).valueAsString != "" && Number(this.getField("2e"+i).valueAsString) != 0){
total += Number(this.getField("2e"+i).valueAsString);
avg++;}}

if(avg != 0)
event.value = total/avg;
else
event.value = "";

     

     

      robertl78874585
      robertl78874585Author
      Participant
      May 19, 2023

      Nesa, 

      I appreciate the input. I actually decided to give ChatGPT a try. It gave me a code that worked like a charm! 

       

      // Custom calculation script for Adobe Acrobat
      // Calculate average of six numerical values, ignoring blanks and zeros

      var values = new Array(
      getField("2e1").value,
      getField("2e2").value,
      getField("2e3").value,
      getField("2e4").value,
      getField("2e5").value,
      getField("2e6").value
      );

      var sum = 0;
      var count = 0;

      for (var i = 0; i < values.length; i++) {
      var value = parseFloat(values[i]);

      if (!isNaN(value) && value !== 0) {
      sum += value;
      count++;
      }
      }

      var average = count === 0 ? 0 : sum / count;

      event.value = average;

        robertl78874585
        robertl78874585Author
        Participant
        May 19, 2023

        Here is what the form looks like. 2.a.6. is not always required. The average for 2.a.1-2.a5. is easy. However, I want 2.g to consider the score for 2.a.6. when it is used. 

         

        Terms & ConditionsAccessibility statement
        Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices