Count if on button

[venkatg6759]

Hello all,

i am trying to get this expression by using button.

=aggr(Count([Security Name]),[% GUID]) Where i need only 1 to be selected

if(Count(SecurityName)=1,SecurityName)

i need 1 to be selected on click of button.

I tried using select in field but unable to get the answer.

Any helpful ideas?

Thanks in Advance,

Venkata

[alexandros17]

Use this function:

=GetSelectedCount(MyField)

let me know

[venkatg6759]

That doesn't work!

i need number, individual security to be selected

suppose if count  gives you 1,2,3,4

i need 1 to be selected from the count .

[#4]

Try:

If(GetSelectedCount(SecurityName) = 1, aggr(Count([Security Name]), [% GUID]))

[alexandros17]

=If(GetSelectedCount(SecurityName)=1, SecurityName)

[venkatg6759]

I tried but it doesn't ,

I created a listbox expression by

aggr(Count([Security Name]), [% GUID]))

which gave me 1 ,2,3 .........

i don't want to go that list box and select 1 ,instead i want to click the button and select 1