Getselectedcount listbox with calculated values

[curiousfellow]

I created a listbox with calculated values, this listbox is connected to an alternate state.

For a chart I want force that one item from that listbox is chosen.

How do I refer to this listbox in the function getselectedcount() ?

[Anil_Babu_Samineni]

Not sure, I understand your rek. But, Normally it can be done like below

If(GetSelectedCount(FieldName) = 1, Only({AlterNateState<......>} FieldName1)

[curiousfellow]

The problem is that there is no fieldname, Because it is a calculated value.

For instance : if(Right(fieldname,2)=3, left(fieldname,4))

[sunny_talwar]

May be this

=GetSelectedCount(fieldname, False(), 'AS') = 1

[sunny_talwar · Accepted solution]

Or this

Count({AS}DISTINCT if(Right(fieldname,2)=3, left(fieldname,4))) = 1

[Anil_Babu_Samineni]

Means,, You don't have Field using the same in script.. If so, Create one field in script for that and then use as i mentioned

[curiousfellow]

Thank you. This works