How to set Analysis with Field value exist in other column?

[Anonymous]

Table 1:

Field A	Field B
A	10
B	20
C	30
D	50

Table 2:

Field C	Field D
A	1
B	2
D	3
E	4

How to set an analysis like below where Table 1 and Table 2 are not associated together?

Count (distinct (if(Field B > 0 and (Field A exist in Field C), [Field B])))

Many Thx!

[sunny_talwar]

May be this:

Count(DISTINCT {<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])

[Anonymous]

Hi Sunny,

it seems not work.

Does It only allows putting value in P(Value) instead of P(Field)?

Best Regards

[Anonymous]

It works after adding the $

Count(DISTINCT {$<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])

THX!

[sunny_talwar · Accepted solution]

That is strange because not having anything there is equivalent of having $ (unless you chart is in an alternate state). So essentially these two equations are the same

Count(DISTINCT {<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])

Count(DISTINCT {$<[Field B] = {'>0'}, [Field A] = P([Field C]>} [Field B])