Calculating averages for reponses on repeat

[wroos]

Hello,
See previous discussion, esp…

Does KoBoToolbox has any default average function like Excel

BTW, I dont know the context of where your set of numbers of coming from, but if you have a repeat group and want to, say, generate an average of all the values entered, then there is a very useful function - sum() - which, when used in conjunction with count() - can be used to calculate an average (which is far less messy than writing a bunch of ${a1} + ${a3} + ${a3} …). Again, this is intended for calculation against multiple values collected via a repeat group.

How do we use the calculate function in KoBoToolbox to add 2 variables?

Hi @tanzilhuda, You could calculate the average as shown in the image below: In the survey sheet of your xlsform: [image] Reference xlsform: Addition_Average_Calculation.xlsx (9.7 KB)

You could also have a look at the discussion that has happened in the past (to calculate the average within a repeat group):

Hi Kal, Do you mind sharing the XLSFORM of the above solution? I have used the same approach as you but I keep getting zero as the results of the sum. Thank you

Always feel free to search in the community forum for questions…
Kind regards