Hello! I am attempting to calculate a sum of fields in Survey123 Connect. I have a list of decimal fields that represent the "total of x species" seen in the field. These fields are set up with a relevant formula to only appear if the species is seen (determined from a select_multiple field). The default value for these fields is 0. I also want to also calculate a sum of all the species totals. What I'm finding is that if one of total_SPECIES fields doesn't appear in the survey, the total won't be calculated.
I found this blog and tried the default value technique, but the relevancy seems to be making it weird: https://support.esri.com/en/technical-article/000022441
Here is a screenshot of my spreadsheet:
And a screenshot of my form:
I didn't create a calculation for the whole list of species yet, just to make sure it works before I spend too much time.
Thanks for the help!
Solved! Go to Solution.
I think you are having the same issue as this post https://community.esri.com/t5/arcgis-survey123-questions/constrain-total-value-of-repeat-entries/m-p...
Basically use coalesce or hidden.
Also I would use the selected() method for the relevant not regex. See https://community.esri.com/t5/arcgis-survey123-questions/using-choice-filter-with-a-select-multiple/...
Hope that helps
I think you are having the same issue as this post https://community.esri.com/t5/arcgis-survey123-questions/constrain-total-value-of-repeat-entries/m-p...
Basically use coalesce or hidden.
Also I would use the selected() method for the relevant not regex. See https://community.esri.com/t5/arcgis-survey123-questions/using-choice-filter-with-a-select-multiple/...
Hope that helps
Got delayed on this project, but coalesce worked! Thank you!