4 Replies Latest reply: Oct 31, 2016 4:43 PM by Sunny Talwar

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

Table 1:

Field AField B
A10
B20
C30
D50

Table 2:

Field CField D
A1
B2
D3
E4

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!

• ###### Re: How to set Analysis with Field value exist in other column?

May be this:

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

• ###### Re: How to set Analysis with Field value exist in other column?

Hi Sunny,

it seems not work.

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

Best Regards

• ###### Re: How to set Analysis with Field value exist in other column?

It works after adding the \$

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

THX!

• ###### Re: How to set Analysis with Field value exist in other column?

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])