Average value inside repeats

275
2
01-15-2019 01:55 AM
Highlighted
Occasional Contributor

Hi, Is there any option to calculate the average (the sum of each value entered divided by the number of values entered into a repetition (has no defined value) and can be calculated? 

p.e.

"If you enter 02 values, then divided by 02, if you enter 03 values, divided by 03, if you enter N values divided by N "

I think I've only seen it within ideas of improvements.

Tags (2)
Reply
0 Kudos
2 Replies
Highlighted
Occasional Contributor

It can be done. Here is how I do it in my survey:

Create 2 field Outside the  reapeat group. One field will use the function Count() on a field within the repeat group and the other will use the Sum() function on that same field.

Then simply divide the results.

Highlighted
Occasional Contributor

Thanks, Nicolas

Reply
0 Kudos