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.
