Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've got a question concerning comparing expressions of not associated columns. My set up looks like this:
Table1:
Column1 | Column2 |
---|---|
A | 1 |
B | 2 |
C | 3 |
Table2:
Column3 | Column4 |
---|---|
A | 1 |
A | 1 |
B | 2 |
C | 1 |
C | 2 |
D | 3 |
E | 4 |
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
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.
Hi Matthias,
See attached if this is what you want.
Regards,
Michael
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.