https://community.esri.com/t5/arcgis-survey123-questions/sum-repeat-formula-fails-randomly/m-p/1546093#M59521 <P>Hi to all.</P><P>I have a survey with Plantation Actions Locations and a repeat (related) table with the plants that where planted at each location.</P><P>Lastly, I have outside of the repeat a question that calculates via the Sum Formula (row 15), the total planted plants per location.</P><P>However, when opening the two tables in ArcGIS Pro the sums are incosistent.</P><P>So I have to manually summarize the plant numbers&nbsp; at the related table based on the parentglobalID, and then join this table to the Plantation Actions table so as to make the comparisons and find the wrong values.</P><P>Any ideas why this is happening?</P> Mon, 07 Oct 2024 11:21:34 GMT Cyprus_Forest_Department 2024-10-07T11:21:34Z https://community.esri.com/t5/arcgis-survey123-questions/sum-repeat-formula-fails-randomly/m-p/1546093#M59521 <P>Hi to all.</P><P>I have a survey with Plantation Actions Locations and a repeat (related) table with the plants that where planted at each location.</P><P>Lastly, I have outside of the repeat a question that calculates via the Sum Formula (row 15), the total planted plants per location.</P><P>However, when opening the two tables in ArcGIS Pro the sums are incosistent.</P><P>So I have to manually summarize the plant numbers&nbsp; at the related table based on the parentglobalID, and then join this table to the Plantation Actions table so as to make the comparisons and find the wrong values.</P><P>Any ideas why this is happening?</P> Mon, 07 Oct 2024 11:21:34 GMT https://community.esri.com/t5/arcgis-survey123-questions/sum-repeat-formula-fails-randomly/m-p/1546093#M59521 Cyprus_Forest_Department 2024-10-07T11:21:34Z https://community.esri.com/t5/arcgis-survey123-questions/sum-repeat-formula-fails-randomly/m-p/1546627#M59532 <P>This is redundant and unnecessary:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="abureaux_1-1728403715569.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/116764i821B02C4EB2A553E/image-size/medium?v=v2&amp;px=400" role="button" title="abureaux_1-1728403715569.png" alt="abureaux_1-1728403715569.png" /></span></P><P>I'd recommend clearing the <STRONG>bind:type</STRONG> and <STRONG>bind:esri:fieldType</STRONG> columns and only use them when <EM>absolutely</EM> necessary. And even then, just use one column.</P><P>Beyond that, I honestly don't see anything glaringly wrong with the survey. I can only test in Connect due to capitals (Enterprise doesn't allow publishing with capitals in names), but everything is working as I'd expect it to there.</P> Tue, 08 Oct 2024 16:18:13 GMT https://community.esri.com/t5/arcgis-survey123-questions/sum-repeat-formula-fails-randomly/m-p/1546627#M59532 abureaux 2024-10-08T16:18:13Z