Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
=if((GetSelectedCount(Month)>1)and(GetSelectedCount(Month)<12),
(left(replace(GetFieldSelections(Month,'',12),'(',''),3)&'-'&right(replace(GetFieldSelections(Month,'',12),')',''),3)),
GetFieldSelections(Month))
hi please find the attachment
HI
PFA
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
Try:
=if((GetSelectedCount(Month)>1)and(GetSelectedCount(Month)<12),
(left(replace(GetFieldSelections(Month,'',12),'(',''),3)&'-'&right(replace(GetFieldSelections(Month,'',12),')',''),3)),
GetFieldSelections(Month))
Hi
PFA
Let me know, this is your requirement