topic Sum repeat is causing a empty data entry for the first repeat in the feature service in ArcGIS Survey123 Questions

Sum repeat is causing a empty data entry for the first repeat in the feature service

NatalieSlayden — Wed, 11 Oct 2023 15:17:12 GMT

Hi, I have a repeat and am totaling based on which species is selected and if they select disease. Currently I have a field within the repeat with the calculation CalcACERCondition:

if(selected(${SpeciesType},'Acropora cervicornis') and selected(${GridCondition},'DiseasePresent'), 1, 0)

I then have a field outside of the repeat that sums those "1" values with calculation: sum(${CalcACERCondition})

In my feature service the first repeat is always blank and then the repeats follow. I heard previously this occurs when doing calculations within a repeat. Is there a way to get around this so there are no blank repeat entries?

Thanks for the help!

Re: Sum repeat is causing a empty data entry for the first repeat in the feature service

DougBrowning — Wed, 11 Oct 2023 15:27:53 GMT

Have you tried putting a relevant on the calc line tied to the SpeciesType field? I have seen the blank lines also.

Re: Sum repeat is causing a empty data entry for the first repeat in the feature service

NatalieSlayden — Wed, 11 Oct 2023 17:37:45 GMT

I was not able to get that to work. It seems like when you sum a repeat it automatically sums first entry before you even select anything.

Re: Sum repeat is causing a empty data entry for the first repeat in the feature service

DougBrowning — Wed, 11 Oct 2023 19:43:25 GMT

Mmm for one project I did add a if(count() > 0 or count() > 1 I forget that got around this. Or maybe a relevant on the sum field?