2 Replies Latest reply: Dec 3, 2013 3:18 AM by Matthias Wiciok RSS

    Comparing not associated columns

    Matthias Wiciok

      Hi all,

       

      I've got a question concerning comparing expressions of not associated columns. My set up looks like this:

       

      Table1:

      Column1Column2
      A1
      B2
      C3

       

      Table2:

      Column3Column4
      A1
      A1
      B2
      C1
      C2
      D3
      E4

       

      Now I want to calculate, how often the sum of Column4 grouped by Column3 equals the value in Column2. I got something like

       

      =count(Column1 = aggr(Column3,Column1))

       

      this gets me the number of sets of Column1 which are also in Column3. But I want to get a step further and expand this expression by comparing the sums of Column2 and Column4.

       

      Do you know what I mean? Can you please help me?

       

      Oh, I want these columns not to be associated....

       

       

      Thanks in advance