4 Replies Latest reply: Jan 11, 2017 9:58 AM by Kim Stroupe RSS

    List box expression null remove

    Kim Stroupe

      Hello all,

      I have created a list box with an Employee field.  I created an expression which works.  It shows the Employee and the count of Assets they have.

      =If(Count(DISTINCT {<status = {'Active'}>}Asset_ID)>1,Count(DISTINCT {<status = {'Active'}>}Asset_ID))


      My issue is the counts that aren't greater then 1 have a dash       next to the Employee field.  I don't want those to show up on the list.


      Do you know how I can remove them?  I only want to see Employee 1 below








      I see in list box


      1      2

      2      -


      Thank you for your assistance.