topic Re: Survey123 - Calculate sum of fields that have relevant formulas set? in ArcGIS Survey123 Questions

Survey123 - Calculate sum of fields that have relevant formulas set?

mrosekulick — Wed, 03 Aug 2022 19:02:11 GMT

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!

Re: Survey123 - Calculate sum of fields that have relevant formulas set?

DougBrowning — Wed, 03 Aug 2022 19:21:37 GMT

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/1195098#M43899

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/td-p/731024

Hope that helps

Re: Survey123 - Calculate sum of fields that have relevant formulas set?

mrosekulick — Tue, 23 Aug 2022 23:28:09 GMT

Got delayed on this project, but coalesce worked! Thank you!