Calculating averages for reponses on repeat

[otimhar]

Dear Team,
I have a challenge on creating an automated calculation.
I have a repeat group(repeating several times) to capture averages(for weight of commodity), i would like to get the total averages for the number of repeats entered. What formula can i use? Am creating forms using Kobo form build.
Thank you
Harron

[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

[Kal_Lam]

Hi @otimhar,

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

Calculating inside a loop

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

Have a great day!

[otimhar]

Thank you. I will try these options and get back to you.
Harron

[otimhar]

I shall try this options. thank you
Harron