3 Replies Latest reply on Apr 21, 2017 1:10 PM by Joel_Geraci

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

    jennifer60254621

      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:

      CriteriaRating
      1.13
      1.24
      1.3
      1.42
      1.53

       

      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?