COUNT() used in expression

[Anonymous]

Hi,

I have a COUNT() statement which looks like this in one of the expressions for a chart:

count ( {<Col1_in_Table1={1}>} DISTINCT Col2_in_Table2 )

Can someone let me know if I’m interpreting this statement correctly or not. 

So if my data looks like this:

Col1_in_Table1	Col2_in_Table2
1	X
1	X
1	Y
0	X
0	X

Does the COUNT() in above return 2?

Thank you.

[miguelbraga]

Here it is:

Regards,

MB

[swuehl]

Yes, there's another column which links these two tables.  I just gave a very simplied example but thanks for

pointing this out.

Then the answer will depend on the link between the two tables. A simplified example might not give the same answer as your real data then.