Relevant if not equal to

85
1
Jump to solution
05-07-2019 12:37 PM
Highlighted
Occasional Contributor III

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')?

Tags (1)
Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Esri Regular Contributor

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

View solution in original post

1 Reply
Highlighted
Esri Regular Contributor

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

View solution in original post