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))
COUNT(SELECT(Medical Needs Program Registry PENDING[Caregiver First Name], ISNOTBLANK([Caregiver First Name])))
COUNT(SELECT(Medical Needs Program Registry PENDING[Age], [Age]<=17))
Thank you
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |