Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi gurus,
if i select Month Year it should display month in chart lable
output:Jan,Feb,Mar...........
multiple selection display
Try: purgechar(getfieldselections(Month, ', '), '-0123456789')
- Marcus
Try: = getfieldselections(Month, ', ')
- Marcus
but if i select month year it should display first 3 letters
ex:
source: jan-12,feb-12
output: jan,Feb
Try: purgechar(getfieldselections(Month, ', '), '-0123456789')
- Marcus
Try this:
='Month'&chr(32)&if(GetSelectedCount(Month)>0,'- '&GetFieldSelections(Month))
Thanks,
AS