2 Replies Latest reply on May 2, 2015 9:56 PM by danlee

    Problem with List View Layout

    danlee

      Title

      Problem with List View Layout

      Post

      I have a layout in List View.  I have a field, Trainer.  I only want to show Trainers in that layout when they have Active clients.  I created a calculation field, Case ( ActiveNumber ; Trainer ), ActiveNumber is a calculation field, Count ( Clients|Active::_fkTrainerID ), and it gives me the trainers who have Active clients but it leaves spaces as you can see in the attachment.  I don't want those spaces.  The empty spaces are all the other trainers in the database.  How can I write it up to just show only Trainers with Active clients without all the empty rows.

      Thank you

      Screen_Shot_2015-05-02_at_8.06.09_PM.png