Text box - current selections

[aaronnayan]

Hi guys.

I have a text box that shows information when a certain dimension is selected

the code i have used is

=IF(ISNULL(ONLY(BRNAME)),'',ONLY(BRNAME))

However i want to include another two dimensions ("GRNAME","GBNAME")

I know this maybe very simple but could anyone help me do this please?

[krishnacbe]

Try Below Expression

IF(GetSelectedCount(BRNAME)=1, BRNAME, if(GetSelectedCount(GRNAME)=1, GRNAME, if(GetSelectedCount(GBNAME),'')

But This will work only if you have selected one value in the List box.

[sunny_talwar]

Include them how? May be this?

=IF(ISNULL(ONLY(BRNAME&GRNAME&GBNAME)),'',ONLY(BRNAME & ' ' & GRNAME & ' ' & GBNAME))

[Anil_Babu_Samineni]

I would suggest you to create composite key for required fields and then use same as you required

[aaronnayan]

there is an error in this expression krishna

[aaronnayan]

Hi Sunny only when the a value from BRNAME is selected do all the other values show

The fields work in hierarchy

GBNAME  

GRNAME  

BRNAME  

I want it so as soon as a field is selected it will show what dimension has been selected from the 3

[krishnacbe]

Please try this

=IF(GetSelectedCount(BRNAME)=1, BRNAME, if(GetSelectedCount(GRNAME)=1, GRNAME, if(GetSelectedCount(GBNAME),'')))

[aaronnayan]

a composite key is not needed ANIL its for aethsetic purposes onlly

[aaronnayan]

Hi Krishna very very close! it just does not show GBNAME

[krishnacbe · Accepted solution]

Sorry, my mistake try below expression

=IF(GetSelectedCount(BRNAME)=1, BRNAME, if(GetSelectedCount(GRNAME)=1, GRNAME, if(GetSelectedCount(GBNAME)=1,GRNAME,'')))