AnsweredAssumed Answered

How to get Total Count of value from drop down box

Question asked by danlee on Apr 18, 2015
Latest reply on Apr 19, 2015 by philmodjunk

Title

How to get Total Count of value from drop down box

Post

I have a table Clients with field, ActiveChecked.  I have the control style as a drop-down list with values, Active and Non Active.  How do I create a field that calculates how many Active clients a trainer has?

Example 3 trainers:

Trainer A - 50 clients (30 Active)

Trainer B - 30 clients (10 Active)

Trainer C - 35 clients (12 Active)

Outcomes