https://community.esri.com/t5/arcgis-survey123-questions/repeat-sorting-and-summary/m-p/1582022#M61099 <P>I'm creating an asbestos survey in survey123. Users enter a unique material code (not able to be selected from a pregenerated list) and associated quantity in two different questions within a repeat. For instance Floor Tile-Red : 2,500 SF, Floor Tile-Blue : 1,000 SF, Floor Tile-Red : 1,500 SF. I want to create a list of unique codes entered into the repeat and sum the quantities. So the output would look like the following:</P><P>Floor Tile-Red : 4,000 SF</P><P>Floor Tile-Blue : 1,000 SF</P><P>I've tried the join and count functions outside of the repeat but can't figure out the duplicate material code piece. Any ideas?</P> Tue, 04 Feb 2025 22:06:02 GMT SigmaAdmin 2025-02-04T22:06:02Z https://community.esri.com/t5/arcgis-survey123-questions/repeat-sorting-and-summary/m-p/1582022#M61099 <P>I'm creating an asbestos survey in survey123. Users enter a unique material code (not able to be selected from a pregenerated list) and associated quantity in two different questions within a repeat. For instance Floor Tile-Red : 2,500 SF, Floor Tile-Blue : 1,000 SF, Floor Tile-Red : 1,500 SF. I want to create a list of unique codes entered into the repeat and sum the quantities. So the output would look like the following:</P><P>Floor Tile-Red : 4,000 SF</P><P>Floor Tile-Blue : 1,000 SF</P><P>I've tried the join and count functions outside of the repeat but can't figure out the duplicate material code piece. Any ideas?</P> Tue, 04 Feb 2025 22:06:02 GMT https://community.esri.com/t5/arcgis-survey123-questions/repeat-sorting-and-summary/m-p/1582022#M61099 SigmaAdmin 2025-02-04T22:06:02Z