dynamic selection

[manoranjan_d]

i want to give the expression  label name with dynamic selection of the week

example if i select the week1 in the list box 1, since list box 1 has been defined with state1

then the expression label has to show "week1 total amt"

but this is not working

=Only({[State1]}if(GetSelectedCount(Week_Num1)>=1,Week_Num1,'Week')) & 'total amt'

its not showing

its showing only "week total amt" but as  per the requirement is shd show

"week1 total amt"

bcoz i slected week1 from list box 1 assigned with state1

[Anil_Babu_Samineni]

What if you use some thing like below

=GetFieldSelection(Week_Num1) & 'total amt'

[manoranjan_d]

week_num1 field has been assigned list box with alternate state

[manoranjan_d]

in this expression  how to give the state1

[effinty2112]

Hi,

Try this:

=Only({[State 1]} if(GetSelectedCount(Week_Num1, 'include','State 1')  =1,Text(Week_Num1),'Week')) & 'total amt'

cheers

Andrew