18 Replies Latest reply: Jun 14, 2013 10:59 AM by Antoine Frangieh RSS

    Conditional sum / set analysis

    Antoine Frangieh

      Hello,

       

      I have the following data table:

       

      ABC
      Name 1B110
      Name 1B220
      Name 2B330
      Name 2B440

       

      I want to build a chart that can tell me the sum of the names have no B2.

       

      Note that I tried using the following set analysis:

      sum({$<B={"*"}-{"B2"}>} C)

       

      However, instead of getting 70 (30+40), I am obtaining 80 (30+40+10) which is logical.

      How can I make the expression "behave" so that I can exclude any trace of Name 1 (since one of its occurences contains B2)

       

      Any ideas would be of great value.

       

      Cheers