Listbox Valuelist

reshmakala — Wed, 12 Nov 2014 20:20:26 GMT

Hello all,

I have a list box that gets values from an if condition. My expression is:

=if(Month='1','Jan',

if(Month='2','Feb',

if(Month='3','Mar',

if(Month='4','Apr',

if(Month='5','May',

if(Month='6','Jun',

if(Month='7','Jul',

if(Month='8','Aug',

if(Month='9','Sep',

if(Month='10','Oct',

if(Month='11','Nov',

if(Month='12','Dec'))))))))))))

I get only Oct and Nov based on some transactions. How can put in some dummy values for the months that are not displayed?

I want to display all 12 months, though there are only 2 months which can be selected.

Re: Listbox Valuelist

its_anandrjs — Thu, 13 Nov 2014 14:32:58 GMT

Hi,

Better if you use application with the master calendar then you get all Month value weather it is in transaction or not.

Regards

Anand