topic Re: Using answers to multiple-select question in calculation of another question in ArcGIS Survey123 Questions

Using answers to multiple-select question in calculation of another question

PrachiPatel — Wed, 15 Sep 2021 21:59:46 GMT

I have a select multiple question, where a submitter selects all the alternative water supplies they will use on their site. Then I want to calculate total supply they have available on their site depending on the answers they select.

For example in the screenshot above, if the submitter selects Rainwater and Stormwater, I want the rec_sav to have the calculated value of ${RW} + ${SW}. How do I format the calculation when it is dependent on the answers to multiple-select question that get stored as comma separated values?

Re: Using answers to multiple-select question in calculation of another question

DougBrowning — Wed, 15 Sep 2021 22:14:24 GMT

I think contains would be your friend here.

if(contains(${selectmultiplefield}, "Rainwater") and contains(${selectmultiplefield}, "Stormwater"), ${RW} + ${SW}, else not sure what you want here)

You could also always calc it and instead use relevant to show the whole field it only if they are checked. The relevant would use contains just like above.

Hope that helps

Re: Using answers to multiple-select question in calculation of another question

PrachiPatel — Wed, 15 Sep 2021 22:19:27 GMT

@DougBrowning Worked like a charm, Thanks!