Calculate - simple add function not working

PrachiPatel — Mon, 23 Nov 2020 01:54:44 GMT

A simple add function in survey 123 is not working right.

I have a select multiple for types of commercial use, eg: hospital, retail, education facility etc.

Using relevance, I have calculated no. of employees in each commercial use. So if hospital is selected, then hospital employees will get calculated and so on

Now I want to sum up the total employees. However, lets assume hospital and retail is selected - then hospital and retail employees get calculated but education facility does not get calculated (because education facility was not selected). Therefore survey 123 connect returns no value when I try to calculate hospital emp + retail emp + education facility emp

what can be the work around for this?

Re: Calculate - simple add function not working

PrachiPatel — Mon, 23 Nov 2020 02:10:42 GMT

James Tedrick's response on this other post was helpful

https://community.esri.com/t5/arcgis-survey123-questions/addition-calculations-not-working/m-p/854737/highlight/true#M24456

Solution to use coalesce (${q},0) - so if the commercial use is not selected and therefor has a NaN value in employees calculated - survey 123 will use 0 instead

topic Re: Calculate - simple add function not working in ArcGIS Survey123 Questions

Calculate - simple add function not working

Re: Calculate - simple add function not working