4 Replies Latest reply: Mar 15, 2018 3:45 PM by Fredrik Almqvist RSS

    How to count matching values in 3 different fields

    Fredrik Almqvist

      Hi,

      How do i create an expression where i can calculate how many of the same value it is in the different fields?

        

      Campaign1Campaign2Campaign3
      B
      CAD
      ACB
      DA
      BA

       

      Expecting result:

      A=5

      B=3

      C=2

      D=2

       

      Thanks in advance,

      Fredrik