LOTH and CH Calculations

Notes: Requires Entry Objects and Exit Objects Housing Move-In Date

[Homeless Start Adjusted] = If(IsNull([Approximate date homelessness started:(4355)]);[Entry Exit Entry Date];[Approximate date homelessness started:(4355)])

[Move-In Date] = If(Left([Entry Exit Provider Program Type Code];4)="PH -";If([Entry Objects].[Housing Move-in Date(5093)]>RelativeDate([Entry Exit Entry Date];-1);[Entry Objects].[Housing Move-in Date(5093)];If([Exit Objects].[Housing Move-in Date(5093)]>RelativeDate([Entry Exit Entry Date];-1);[Exit Objects].[Housing Move-in Date(5093)])))

[Move-In Date HH] = NoFilter(Min([Move-In Date]) In([Entry Exit Group UID]))

[Days to Move In] = DaysBetween([Entry Exit Entry Date];If([Move-In Date]>[Move-In Date HH];[Move-In Date];[Move-In Date HH]))

[Homeless End Adjusted] = 
If(Not(IsNull([Move-In Date]));[Move-In Date];
If(Not(IsNull([Move-In Date HH]));[Move-In Date HH];
If(Not(IsNull([Entry Exit Exit Date]));[Entry Exit Exit Date];
If(CurrentDate()>[Report End Date];[Report End Date];CurrentDate()
))))

[Days Homeless] = DaysBetween([Homeless Start Adjusted];[Homeless End Adjusted])

[CH] =
If([Disabling Condition?(1135)]="Yes (HUD)" And 
([Days Homeless]>=365 or
([Total number of months homeless on the street, in ES or SH in the past three years(4357)] InList("More than 12 months (HUD)";"12") AND [Regardless of where they stayed last night - Number of times the client has been on the streets, in ES, or SH in the past three years including today(4356)]="One time (HUD)"));"CH")

[CH HH] = If(Count([Client Uid]) Where([CH]="CH") In([Entry Exit Group UID])>=1;"CH HH")