16 Replies Latest reply: Jun 25, 2014 6:24 PM by Nilo Barreto Pontes RSS

    Question on List box expression

      Hi -

       

      This is a simple question, with I hope a simple answer.  I have a Master Calendar with a Trade_Calendar_Quarter column.  It is 1, 2, 3, or 4 depending upon in which quarter the date falls.  I can create a list box with that column in it, and it shows 1, 2, 3, and 4, as expected.  I wanted it to look nice, so I made it an expression:

       

      ='Q' & Trade_Calendar_Quarter

       

      With that as the expression, it shows Q, Q1, Q2, Q3, and Q4.  The Q is grayed out, as it is not possible.

       

      So the question is really two questions: why does that happen, and how can I not have the Q show up?