How do you do an if or match against multiple selected values?

[Anonymous]

Hi

I have two fields with exactly the same names(Fund1 and Fund2). The user does not make any selections in Fund1, and can selected multiple values in Fund2. I create a scatter plot of all the possible values in Fund1 (my only dimension), and want to highlight the values selected in Fund2 (different colour for the datapoints, and possibly even highlight the names.

How can I check if Fund1 matches any of the values selected in Fund2?

Thanks.

Joao.

[tresesco]

I am not sure i fi have got your requirement. May be:

Exression like this ? If (Fund1=Fund2, Fund1)

Thanks.

[#3]

if(len(GetFieldSelections(Fund2))>0 ,
  Sum( {< Fund1={'$(=GetFieldSelections(Fund2))'}}>}Value)
)

regards-bika

[Anonymous]

Thanks, but Fund2 has multiple selections. Will that work?

[Anonymous]

I'm not following the logic. If more than 1 selection is made in Fund2, you sum the values?

I want to know everytime Fund1 matches Fund2, so that I can color the datapoints!

Thanks.

Joao.