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

# Comparing not associated columns

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.

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

• ###### Re: Comparing not associated columns

Hi Matthias,

See attached if this is what you want.

Regards,

Michael

• ###### Re: Re: Comparing not associated columns

Well, this is the right direction. But I want to count the Yes-Rows.

I solved this matter by creating a new table and there store the values. See attached file for this.