Sum values from multiple repeat fields

Idea created by DCRW_erica.tefft on Nov 5, 2019
    New
    Score70
    • DCRW_erica.tefft
    • DCRW_craig.fitzgerald
    • sphilippus
    • UrbTree_FranciscoRod
    • mtrust
    • Buckeye18
    • Samantha_Coccia_Schillo

    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.