2 Replies Latest reply: Feb 2, 2018 12:48 PM by Robert Hutchings RSS

    Unique count & sum

    Achille Spacciante

      Hey

      I´m new in this forum and I need your help. J

      I need to get a numeric result (0,1 or 2) based on following conditions:

      Field1 = Unique value

      Field2= only for references that starts with 20, 40 or 45

      That means:

      • if Field2 contains LCL the value in the Result column must be 0
      • if field2 contains 20 (as first 2 digits), the value in the Result column must be 1 – regardless how many duplicates are in the Field1
      • if field2 contains 40 or 45 (as first 2 digits), the value in the Result column must be 2 – regardless how many duplicates are in the Field1

       

      forum.PNG

       

       

       

        Can you help me=?

      Thank you