AnsweredAssumed Answered

Problem with List View Layout

Question asked by danlee on May 2, 2015
Latest reply on May 2, 2015 by 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

Outcomes