Creating sum from dropdown

320
4
12-29-2021 02:51 PM
godofsix
New Contributor II

Hi,

 I'm trying to create a sum field using the input from a drop down. I have a form where individuals are asked of the age and I would like a field that will hold the sum of the various age ranges (0-17,18-29,29-30 etc). I tired doing this in Survey123 Online but the calculation is not active

0 Kudos
4 Replies
Katie_Clark
MVP Regular Contributor

Is the question within a repeat? Is this what you're trying to do? 

https://support.esri.com/en/technical-article/000021664

Best,
Katie


“The goal is not simply to ‘work hard, play hard.’ The goal is to make our work and our play indistinguishable.”
- Simon Sinek
0 Kudos
godofsix
New Contributor II

Looks similar but my intention is something like this: If age = 0-17 then field 0-17 should hold the total/count entries for 0-17: Same for if age = 18-19 then field 18-19 should hold total/count entries for 18-19.

0 Kudos
Katie_Clark
MVP Regular Contributor

Would the "count" function do what you need?

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm 

 

Best,
Katie


“The goal is not simply to ‘work hard, play hard.’ The goal is to make our work and our play indistinguishable.”
- Simon Sinek
0 Kudos
godofsix
New Contributor II

I tried that in Survey123 online but the calculate didn't work. Let me try in the xlsform

0 Kudos