Select to view content in your preferred language

Sum Repeat formula fails randomly

230
1
10-07-2024 04:21 AM
Cyprus_Forest_Department
Regular Contributor

Hi to all.

I have a survey with Plantation Actions Locations and a repeat (related) table with the plants that where planted at each location.

Lastly, I have outside of the repeat a question that calculates via the Sum Formula (row 15), the total planted plants per location.

However, when opening the two tables in ArcGIS Pro the sums are incosistent.

So I have to manually summarize the plant numbers  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.

Any ideas why this is happening?

0 Kudos
1 Reply
abureaux
MVP Frequent Contributor

This is redundant and unnecessary:

abureaux_1-1728403715569.png

I'd recommend clearing the bind:type and bind:esri:fieldType columns and only use them when absolutely necessary. And even then, just use one column.

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.

0 Kudos