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:
Floor Tile-Red : 4,000 SF
Floor Tile-Blue : 1,000 SF
I've tried the join and count functions outside of the repeat but can't figure out the duplicate material code piece. Any ideas?
