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?
James Tedrick's response on this other post was helpful
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