Average calculation

1. What is the issue? Please be detailed.
How do I write the average calculation formula in .xls file I'm creating for odk

2. What steps can we take to reproduce this issue?

3. What have you tried to fix the issue?

I have fixed row errors
4. Upload any test forms or screenshots below.


This is what I used in a recent form to calculate average:

Select 'type = calculate', set some variable-name in 'name' column, and in calculation column, put following:

round((${learners_benchmarking} + ${parents_involvement} + ${parents_participation_in_CEC} + ${local_community_involvement} + ${school_resources_sharing} + ${CEC_interest}) div 6)

The values of variables are coming as numeric input from the questions above this row.

Remove the ROUND function if you don't want rounding off.

Hope it helps.

1 Like