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

    Conditional sum / set analysis

    Antoine Frangieh



      I have the following data table:


      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.