The formula below identifies all individuals latest exit within report period.
=If([Exit Date] = Max(TOTAL <[Client Id]> Date(Floor(Num(IF([Exit Date Adjusted]>'3/31/2019',0,Date(Floor([Exit Date]))))),'MM/DD/YYYY')),
If([Entry Date] = Max(TOTAL <[Client Id]> [Entry Date]), 'Yes'))
I need to add the following criteria to the formula :Household Head of Household]={"Yes*"} .
I can't figure it out.