Skip to Content
0
Former Member
Aug 15, 2016 at 10:00 AM

Can I change the view of a COMBOBOX selection

33 Views

Hi experts.

I am trying to put together an easy COMBOBOX selection for the input section of a modified BPC script.

Basically, due to the way that our months are numbered, in general, month 001 is September (through to August being month 012), and everybody is used to this being the case.

However, for one of our exports, the month numbers are standard (Jan = 01, etc.), due to it feeding in to a different system that uses that format.

To avoid confusion, I would like to present the users with a list that is shown in name format, but with the selection converted to a number when they select it.

Is this possible?

e.g.

Instead of

PROMPT(COMBOBOX,%PER%,"Select Period",0,,{01,02,03,04,05})

I would like

PROMPT(COMBOBOX,%PER%,"Select Period",0,,{Jan,Feb,Mar,Apr,May}) - Then convert this to {01,02,03,04,05}

Thanks for taking a look and I hope that somebody has already wrestled with this sitiuation. :-)

Regards

Chris

NB - This is a BPC NW 10 system.