I’ve gotten half my totals to work.
Having trouble with counts though.
Even though I have used different column names all the name/text columns I’m trying to get counts for have the same total - so I’m assuming its counting each row not just the non-blank rows.
Could someone help me with that expression?
=COUNT(SELECT(Medical Needs Program Registry PENDING[Caregiver First Name], TRUE))
Also, I can’t get age expression to work:
=COUNT(SELECT(Medical Needs Program Registry PENDING[Age], <=17))