Sum Repeat formula fails randomly

Cyprus_Forest_Department

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?

exportwebsite.xls

Plantation_Actions.xlsx

Tautvydaslgaitis_0-1737381950415.png

MCh_8-1737381352346.png

abureaux

This is redundant and unnecessary:

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.