nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculating a final total from repeats, Survey123?

SunnyF

Hi,

I know that it is possible to have a final total at the bottom of a survey based on a group of questions. I have a repeat group and I'd like to have a total to calculate all the entries from the repeats. What is the proper syntax for this?

Thank you!

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

IsmaelChivite

Hi! Thanks for your feedback. This is in our back-log at the moment. Please if not already vote for and comment on this idea: https://community.esri.com/ideas/12210

SunnyF

Hey Ismael,

I went and voted for it as a future built-in feature. In the meantime, are you aware of any workaround syntax?

Best,

Sunny

IsmaelChivite

Hi Sunny. No workarounds that I am aware of. Sorry.

BiosisGIS

Hi Sunny,

I have a bit of a clunky workaround. Instead of having your questions in a repeat, you have to duplicate them as many times in the main survey as you think there could be possible responses. So rather than having species name and count in a repeat I have Species1Name, Species1Count then Species2Name, Species2Count and so on up to a couple of dozen species. I then put relevant restrictions on each one so that the species 2 fields only appear if there are values for species 1. It then means you can use the count field in calculations, though it means you end up with a very long calculation that capture the values from all the fields. It also adds lots of fields to your main form and I find if any of the repeat fields have long choice lists (as my species field does) then the more iterations you add of a field looking up the long list, the slower the form is to run to the point where my form refuses to run after about 4 iterations of the species field which is looking up an external choice list of a couple of thousand choices. As I said, a bit clunky but it works if you don't need to have too many repeated records, too many fields in your repeats or too many choices for one of your fields in the repeat.

Hope this helps,

James.

deleted-user-5MTyXPMg0TSw

I'd definitely use the feature of getting a sum from within a repeated group. Thanks!

JamesTedrick

Hi Rosemary,

This was actually added over the summer to Survey123 - see the "Repeat Aggregated Functions" topic in https://community.esri.com/groups/survey123/blog/2017/06/02/world-milk-day-release-21 as well as Repeats—Survey123 for ArcGIS | ArcGIS

deleted-user-5MTyXPMg0TSw

Thanks so much! I had seen SUM in the list and gave it a try but it didn't work. User error! I used regular parentheses instead of curly brackets. Thanks again -- it works like a charm!

FernandoTroncoso

Hi James Tedrick

Is there a limitation to perform the sum ($ {question}) function with hidden (relevant) questions?

I have a question outside the repeat (question_3), with a function to add the values of a question into the repeat (sum ($ {question_2}).

Additionally question_2 is hidden based on another question ($ {question_1} = 'AAA').

If question_1 is different 'AAA', question_2 will have no value, therefore question_3 will not return any value.

This behavior generates that if in question_5 we want to add question_3 with question_4, question_5 does not return any value.

Whereas all questions are 'interger'

Best regards!!

JamesTedrick

Hi Fernando,

As described in the Empty Values section of Formulas—Survey123 for ArcGIS | Documentation , if a question with no value is involved in a calculation, the result is no value. If you have a question with a possibly null value in a formula, I would recommend using the coalesce() function to test for null and provide a default value if it is null. For addition, that default value normally is 0 (as any value +0 is the original value).

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.