Household Type

=(If(NoFilter(Count([Client Uid])) In([Entry Exit Group UID])=1 And ([Client Age at Entry]>=18 Or IsNull([Client Age at Entry]));"SA";
If(NoFilter(Count([Client Uid])) In([Entry Exit Group UID])=1 And [Client Age at Entry]<18;"UM";
If(NoFilter(Count([Client Uid])) In([Entry Exit Group UID])>1 And NoFilter(Count([Client Uid])) In([Entry Exit Group UID]) = NoFilter(Count([Client Uid]) Where([Client Age at Entry]>=18)) In([Entry Exit Group UID]);"AO";
"AC"
))))