12 Replies Latest reply: Aug 25, 2015 4:07 AM by Richard Chilvers RSS

    String Aggregation Function for matching text

    Richard Chilvers

      My data looks like:

       

      Code, Description, Value

       

      ABC, 20% discount , £100

      ABC, 20% discount voucher, £200

      ABC, 20% discount with money back, £140

      DEF, another discount, £20

       

      etc.

       

      I have a straight table chart to aggregate (SUM) values by Code:

       

      ABC £340

      DEF £20

       

      etc.

       

      Is there a string function to show the first n matching characters in Description?

      Eg. ABC, 20% discount, £340