topic How to sum a repeat variable in a report template in ArcGIS Survey123 Questions

How to sum a repeat variable in a report template

Todd — Fri, 22 Oct 2021 22:18:02 GMT

I have a survey which collects event information and the volunteers who participate at each event. The volunteer and paid hours are tracked.

In my survey the volunteer info is a repeat to capture multiple volunteers per event.

I need to generate a report showing the sum of volunteer and paid hours. Can someone point me in the direction (possibly with a related example. I did see the photos one.) ? Much thanks in advance?

$<$summary>

${#Event .....}

${#rpt_volunteers}

${hours_type_volunteer}, ${hours_type_paid}

${/}${/}

$</>

Re: How to sum a repeat variable in a report template

AlfredBaldenweck — Mon, 25 Oct 2021 19:51:23 GMT

Edit: (oops) For a new survey:
Try making a separate "hidden" or "calculate" question outside of the repeat with count(repeat), sum(repeat), or join(repeat) in the calculation field (your use case is probably sum() ), and then have your report only draw from that question, rather than the repeats themselves.

Repeats—ArcGIS Survey123 | Documentation (See Aggregation section)

Formulas—ArcGIS Survey123 | Documentation

How To: Calculate the sum of repeats in ArcGIS Survey123 (esri.com)

Sorry, not sure off the top of my head for after you have the data