1 Reply Latest reply: Oct 3, 2013 7:27 AM by Tresesco B RSS

    minus fields

    ahnet ceylan

      Hello everyone ,

      I have 3 sets They includes mutual values in both sets

      I want to count values for each set at only that sets

       

      For example

      a--> 1,2,3

      b--> 2,5

      c--> 1,6,7

       

      I want distinct values belong to only that sets

       

      count(a) = one value (3)

      count(b) = one value (5)

      count (c)= two values (6,7)

        • Re: minus fields
          Tresesco B

          Say your field name is DataField(With values 1,2,3,4,5,6,7). Now,

           

          Count(a) Expression: =Count({<DataField={1,2,3}>} Distinct DataField)

          Count(b) Expression: =Count({<DataField={2,5}>} Distinct DataField)

          Count(c) Expression: =Count({<DataField={1,6,7}>} Distinct DataField)