Quarter Function

[dunnalahk123]

Hi,

Can some one help me here

i have Quarter field and values like below

Q118, Q218, Q318, Q418,Q119

but i want to get max Quarter as Q119  how can i write

and next should be Q418

and Next should be Q318

and Next should be Q218

and Next should be Q118

i need 5 variables for above.

Best Regards,

HK

[pradosh_thakur]

maxstring(right(fieldname,2)& left(fieldname,2))

[pradosh_thakur]

I am sorry , i thought you want it to be sorted try below for indivisual value

firstsortedvalue(dim, -num(right(dim,2) & mid(dim,2,1)),1)
firstsortedvalue(dim, -num(right(dim,2) & mid(dim,2,1)),2)
firstsortedvalue(dim, -num(right(dim,2) & mid(dim,2,1)),3)
firstsortedvalue(dim, -num(right(dim,2) & mid(dim,2,1)),4)
firstsortedvalue(dim, -num(right(dim,2) & mid(dim,2,1)),5)