Sum values from multiple repeat fields

97
0
11-05-2019 09:36 AM
Status: Open
Occasional Contributor III

Currently, it is possible to sum the values across one repeat using the syntax sum(${survey_question}) within your XLS form.

I would like to see the ability to create an equation that can deal with multiple sum statements, allowing survey designers the ability to add/subtract the total value summed across one repeat field with the total value summed across another repeat field.

For example:

sum(${survey_question1}) + sum(${survey_question2})

sum(${survey_question1}) - sum(${survey_question2})

sum(${survey_question1}) + sum(${survey_question2}) - sum(${survey_question3})

Esri Technical Support stated "since there is already a workflow to reach our end goal (able to sum one field) we don't think the enhancement will go far." I'm hoping that others out there would also like this ability so this gets some traction with the Survey123 development team.