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

expressions
(Tammi Canelli) #1

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

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

(Aleksi Alkio) #3

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

(Tammi Canelli) #4

Thank you