Survey123 Connect Relevant Formula if field value between two numbers

975
1
05-23-2020 07:03 PM
MaryEllenRosebrough-Gay
New Contributor

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.

Tags (1)
1 Reply
MaryEllenRosebrough-Gay
New Contributor

Figured it out, I needed the income or's to be and's

((${income} >= 24981 and ${income} <= 74490) and ${how_many_people_live_with_you} = 'live_alone') or ((${income} >= 33821 and ${income} <= 101460) and ${how_many_people_live_with_you} = 'me_and_1_other_person')

0 Kudos