GetFieldSelections

[#1]

Hi, people

i have this func:GetFieldSelections(filed)  and i have an Multiple select and i want to get the higest select.

like: 2010,2011,2012 and get only 2012. (i do it on variables)

Someone know how to do it?

[#2]

Hello.

Try with Max(field)

Create a variable with:

=Max(field)

[#3]

thankes for answering but it's still not working

this is what i do

=GetFieldSelections($(vMaxYear))

but isn't give any value in the text box (for cheaking)

[MayilVahanan]

Hi,

     Create a variable like vMaxYear = max(Year)

     and use the variable in text box like =vMaxYear

     and select the years in list box.. You will get the maximum year ,,

Hope it helps

[#5]

i try to be more clear

the user select years:

and i want to take the max year from is select.

if i use GetFieldSelections(years) i get this in text box: 2009,2010,2011.

Now  i want to get the max result in this case :2011

what can i do?

[MayilVahanan]

Hi,

Can you say the result of max(years) in your case. That help to fix the issue.

[#7]

2012

[MayilVahanan]

Hi,

     Did you check after select the years, and if so, please give in the text  object itself ,and check once = max(years) without variable .. I hope it works...check the filed name once..

[#9]

it is working in the textbox, but when i put it in the func: =GetFieldSelections($(vMaxYear))

i get null.

what can i do?

[#10]

I have a 3 table of big,good(up) and bad(Down) brunchs and a chart to show the progres in time line.

now, when someone select for e.g. 2009,2010,2011 he get in the chart the up & down every month/Q/year

and in table he should get the change from 2009 till 2011 the problem is when he clik more than one year

he get null if it only to year i have soulition =GetFieldSelections(KeyYear)-1 and it work

but i want more dinamic for the user.