AnsweredAssumed Answered

Survey123 Connect Relevant Formula if field value between two numbers

Question asked by MaryEllen.Rosebrough_Gay_Yolo on May 23, 2020
Latest reply on May 24, 2020 by MaryEllen.Rosebrough_Gay_Yolo

I need help with the following formula to make a group of fields display based on a range of income and some other field values.

 

If apply_status = yes and entered_by = 211 -> display the group

OR

If apply_status = yes and how_many_people_live_with_you = me_and_1_other_person and income is between 33821 and 101460 -> display the group

OR

If apply_status = yes and how_many_people_live_with_you = live_alone and income is between 24981 and 74940 -> display the group

 

Here is what is not working:

 

(${apply_status}='yes' and ${entered_by}='211') or (${apply_status}='yes' and ((${income}<='101460' or ${income}>='33821') and ${how_many_people_live_with_you} = 'me_and_1_other_person') or ((${income}<='74940' or ${income}>='24981') and ${how_many_people_live_with_you} = 'live_alone'))

 

Thank you.

Outcomes