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

       

       

       

      EmployeeAssetstatus
      1215369Active
      136985Active
      236895Active

       

       

       

      I see in list box

       

      1      2

      2      -

       

      Thank you for your assistance.

       

      Kim