Max of month year value

[razvan_brais]

Hy guys ,

Please help.

I have values for each month :
Jan-1

Feb-3

Mar-2

Apr-4

May-7

Jun-6

Jul-9

Aug-12

Sep-33

Oct-1

Nov-4

Dec-2

I need to take the maximum value from those month : 33 in this case . I need this to be done in an expression. Could you please help.

Thanks,

Razvan

[shreya_nadkarni]

Try this:

SUBFIELD(month ,'-',2) as num

then can take max(num)

[shreya_nadkarni]

max(SUBFIELD(num,'-',2))

[razvan_brais]

The data is not as a string. It is in a table , in different columns. One column for month , and another for values.

An I need to calculate the max without selecting any month...

[shreya_nadkarni]

Can u make a variable

vmax =max(value)

and expression like

if(value=vmax,value) and month as dimension.