in multiple selection find max value

[manoj217]

i have a year list box and i selected 2010 ,2011 ,2012 by led check boxes i want find the max of year in my current selection

[Anil_Babu_Samineni]

Where you want to show Maximum ?

[swuehl]

=Max(YearField)

?

[arvind_patil]

Hi Manoj,

If All field values you had selected in single filed then simply use.

Max(Year)

Thanks,

Arvind Patil

[manoj217]

it will show only the highest year in the year field but  i want highest year in my current selections.  in Year list box i have taken led check box so i can select multiple years . now i want to find the max year in my selection.

[manoj217]

i have 1 to 10 yrs in list box, but i selected 1 ,4, 6, 7 by  multiple selection now i want to show the max value of my selections (7)

[devarasu07]

Hi,

Can you try like this?

Max({1}Year)

[manoj217]

i have selected 2014 so it will shows 2014 but if i select 2014 and 2015 it will shows '-'  so plz suggest

[Anil_Babu_Samineni]

Don't require anything here, Use Max(Year) and select 2/3 then check how Text box returns, And for your condition you may need this

=If(GetFieldSelections(Year) = Max(TOTAL Year), Year)

[swuehl]

Max(YearField) should show you what you want, the highest value in your selection.

You may use GetSelectedCount( YearField ) to check if something has been selected at all, to handle all values being possible, not selected.

=If(GetSelectedCount( YearField ), Max(YearField ))