Max of values selected

[Anonymous]

Hi

I have a field called 'MonthName' with values Jan-Dec.

If multiple values are selected say Jan,Feb,Mar how to find the maximum of the month selected.

I tried giving Max(GetFieldSelections(MonthName)) but i dint ge the Max month selected. It was showing '-'.

Can anyone help me with a correct expression please?

Thanks!

[tresesco]

If you have created this field in the script using Month(), you could simply use max like:

If(GetSelectedCount(MonthName), Max(MonthName))

[PrashantSangle]

Hi,

just try max(MonthName)

Regards

[MK_QSL]

Use below

=SubField('$(MonthNames)',';',Max(InvoiceMonth))

[svenkita]

does the table have any date field then on selection of the months

do

MonthName(max([Date Filed]))

[Anonymous]

When i use the above expression its returning 'Jan1990' when Jun is selected.

[sushil353]

It seems your monthname is text value not in the date format..

so you can simply load inline data for Monthname and value and link that with you model and then do max of value or else calculate your monthname from a date function.

Date(datefield,'MMM') as monthName

or

load * inline

[

monthname,value

Jan,1

Feb,2

Mar,3

soon

];

HTH

Sushil

[Anonymous]

Is 'MonthNames' an variable? And can i Know what is that InvoiceMonth.Is that the Month field used in you expression?

[MK_QSL · Accepted solution]

=SubField('$(MonthNames)',';',Max(InvoiceMonth))

MonthNames is system Variable

InvoiceMonth you need to replace by your MonthFieldName

[Anonymous]

Thanks a lot for the help.