I've gotten half my totals to work. Having t...

[Tammi_Canelli]

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))

[Aleksi_Alkio]

COUNT(SELECT(Medical Needs Program Registry PENDING[Caregiver First Name], ISNOTBLANK([Caregiver First Name])))

[Aleksi_Alkio]

COUNT(SELECT(Medical Needs Program Registry PENDING[Age], [Age]<=17))

[Tammi_Canelli]

Thank you