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

[PrachiPatel]

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?

[DougBrowning · Accepted solution]

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

[PrachiPatel]

@DougBrowning Worked like a charm, Thanks!