I want to calculate the sum of all the numeric fields in my form and its average. How can I do this?

I want to calculate the sum of all the numeric fields in my form and its average. How can I do this?

To find the sum of numeric field values in a form, add a formula field with the expression (field1 + field2 + field3), where field1, field2 and field3 are deluge names of the respective numerical fields in the form. Let's consider a form containing number fields to store the marks obtained in subjects: English, Maths and Science. The field "Total Marks" and "Average" are formula fields to calculate the total and average marks obtained and its expressions are as suggested below.

Total Marks Field:

  1. (Maths + English + Science)

Average Field:
  1. ((English + Maths + Science) / 3)
Note: The above solution would work only while the concerned fields are of numerical type and would not work for single line fields collecting numerical information. 

    • Related Articles

    • Formula custom fields

      A formula field will automatically calculate and derives its value by referring to the value of the specified fields or the numeric, text, or date values given in the formula. You can customize fields with formulas using functions like numeric, ...

    • Task layouts & fields

      Zoho Projects supports custom fields and layouts for tasks. Create your own fields and task layouts and use them for creating tasks as per your business requirements. Click here to learn more about access privileges for Custom Fields and Task ...

    • How do I to calculate the average velocity of my team?

      To calculate the average velocity, your team must have completed at least two sprints for that project. Knowing the average velocity (points completed in all sprints/number of sprints), the team will be able to anticipate how many estimation points ...

    • How can I calculate the number of days between two date fields?

      To calculate the number of days between two given date fields, for instance, ServiceStartDate and ServiceEndDate, add a formula field to the form with formula expression as below. ((ServiceEndDate - ServiceStartDate) / (1000 * 60 * 60 * 24)) ,where ...

    • How can I calculate the number of hours between two date and time fields?

      To calculate the number of hours between two date and time fields, add a formula field and specify the formula expression as ((To_Date - From_Date) / (1000 * 60 * 60))   form Sample { FromDate ( type = datetime ) ToDate ( type = datetime ) Hours ( ...