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