4 Replies Latest reply: Oct 31, 2016 4:43 PM by Sunny Talwar RSS

    How to set Analysis with Field value exist in other column?

    Louis Lam

      Table 1:

      Field AField B
      A10
      B20
      C30
      D50

       

      Table 2:

      Field CField D
      A1
      B2
      D3
      E4

       

      How to set an analysis like below where Table 1 and Table 2 are not associated together?

      Count (distinct (if(Field B > 0 and (Field A exist in Field C), [Field B])))

       

      Many Thx!