topic Re: Quarter Function in App Development

Quarter Function

dunnalahk123 — Fri, 02 Apr 2021 07:47:49 GMT

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,

Re: Quarter Function

pradosh_thakur — Wed, 13 Feb 2019 16:08:51 GMT

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

Re: Quarter Function

pradosh_thakur — Wed, 13 Feb 2019 16:23:31 GMT

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)