help regarding selections

[shree909]

Hi iam attaching a file

which conists for months from Jan to dec

this selection i want to implement at the label level

when i select  jan, apr manually it shows correct(Jan-Mar)

but when i split the months into quarters it doesnt show properly.it shows as (ja-ar)

please find the file as attached

[shree909]

hi please find the attachment

[MayilVahanan]

HI

PFA

[shree909]

it works fine for q1  and q2 ,

but when i select manually jan, apr ,jun it has show as

jan-apr but it shows as differnt .

can u rectify it

[Gysbert_Wassenaar · Accepted solution]

Try:

=if((GetSelectedCount(Month)>1)and(GetSelectedCount(Month)<12),

(left(replace(GetFieldSelections(Month,'',12),'(',''),3)&'-'&right(replace(GetFieldSelections(Month,'',12),')',''),3)),

GetFieldSelections(Month))

[MayilVahanan]

Hi

PFA

Let me know, this is your requirement