How to sum a repeat variable in a report template

124
1
10-22-2021 03:18 PM
Todd
by
New Contributor III

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}

${/}${/}

$</>

Thanks,
Todd
0 Kudos
1 Reply
AlfredBaldenweck
Occasional Contributor II

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

0 Kudos