5 Replies Latest reply: Feb 24, 2015 5:51 AM by Onno van Knotsenburg RSS

    Count of distinct serial numbers, some with extensions

      Hi All,



      I need your help with an expression. Currently I am trying
      get a count of distinct serial numbers, but some of my serial numbers are
      listed as






      So the expression sees these as 2 distinct serial numbers. But
      I need these to be seen as the same SN. How can I get my expression to read these as 1
      distinct serial number?