Relevant if not equal to

Question

Currently have an equal in the Relevant field listed as

${FLOAT}='SEWAGE' or ${FLOAT}='SHEEN' or ${FLOAT}='SILTY' or ${FLOAT}='SUDS' or ${FLOAT}='OTHER'

Is there an equal similar to selected(${FLOAT}, !='NONE')?

Jim Moore · Accepted Answer

Hi Carl

The not() function might do the trick, as mentioned here: https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

For example: not(selected(${FLOAT}, 'NONE'))

If ${FLOAT} is a select_one question, you could also use: ${FLOAT} != 'NONE'

Please let me know if either of these are useful in your case.

Best regards,

Jim