1 Reply Latest reply on Apr 19, 2015 9:03 AM by philmodjunk

    How to get Total Count of value from drop down box

    danlee

      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)