4 Replies Latest reply on Jul 26, 2011 1:23 PM by gkaiseril

    Average Calculation Script

    BellsyTO2

      I have a question about the averages calculation.

       

      I have four form fields (1,2,3,4) and one field for the calculation (5).

       

      If only 1 of the forms is filled in, it gives the average based on if all four were filled in. Example: If one form has a value of 20 and none of the other forms are filled in, than the average is 5.

       

      I would like to only calculate the average for the forms that are filled in. If one form is filled in at 20, than the average is 20. Is there some script that can do this?

       

      Any help is greatly appreciated! Thanks.