The sum of repeats is calculated using the sum() function outside the repeat section. Follow the steps below to calculate the sum of repeats in ArcGIS Survey123:
- Open ArcGIS Survey123 Connect and create a survey using an Advanced template.
- Click the Open XLSForm spreadsheet icon to open the Excel form.
- Configure the form to contain a repeat section.
- Outside the repeat section, create an integer or decimal type question. In the calculation column, use the sum() function to calculate the sum of repeats.
The image below shows the sum() function configured in the calculation column outside the repeat section. The sum() function is used to calculate the total number of items and the total number of boxes collected based on the details provided in the repeat records.