Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use this function:
=GetSelectedCount(MyField)
let me know
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 .
Try:
If(GetSelectedCount(SecurityName) = 1, aggr(Count([Security Name]), [% GUID]))
=If(GetSelectedCount(SecurityName)=1, SecurityName)
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