Getselectedcount issue.

[rdsuperlike]

I want the text box to show only the result that user selects out of the 3 dropdowns, Finance,Rollup,DH.

Right now the below formulae shows all the results that come up and are connected when user selcts one dropdown.

eg: If user selects Finance = "abc", then since bcz of associtivity Rollup = "xyz" and DH = "wdf" also gets printed on the text box. Another user can select Rollup = "xyz. Basically in textbox I want to select the green value, i.e the one selected out of the above 3 dropdowns

Formulae:

if(GetSelectedCount([Finance])=0 and GetSelectedCount([Rollup])=0 and GetSelectedCount([DH])=0, 'Overall View', [Finance] & [Rollup ] & [DH])

Any help is appreciated.

Thanks.

[MK_QSL]

Field Functions

[johnw · Accepted solution]

I may not have understood, but maybe this?

if(GetSelectedCount([Finance]),[Finance]
,if(GetSelectedCount([Rollup]),[Rollup]
,if(GetSelectedCount([DH]),[DH],'Overall View')))

[krishnacbe]

Try below expression:

if(GetSelectedCount([Finance])=0 and GetSelectedCount([Rollup])=0 and GetSelectedCount([DH])=0, 'Overall View', GetFieldSelections([Finance]) & GetFieldSelections( [Rollup ]) & GetFieldSelections([DH]))