Forum Discussion
EvanMartinez
7 years agoModerator
Hi Steph,
In your Income Status field you most likely want something like
In your Income Status field you most likely want something like
If([Total Number of Household Members]=1 and [Total Monthly Income]>1264, "Over Income", "")That way it will evaluate for those two conditions and if they aren't true it will simply stay blank. It might need to be adjusted if your field names are slightly different in your table. I hope that is helpful as a starting point.