Get rid from second expression in list box

[Anonymous]

Hello Everyone,

Can anyone help me in getting rid of the second value from the list box?

I have a list box with Month field but the field is in numeric format. I want in text format.

So, I used  =if(Month1=2,'Feb',If(Month1=3,'Mar',if(Month1=4,'Apr','May'))) this formula in expression but getting the result in given in the attachment .

Thanks in advance for the help.

[swuehl]

Use your expression not in the expression tab of the list box properties, but as calculated field / dimension on general tab (select <expression> from field drop down list and enter your expression).

You can also use something like

=Month(Makedate(2017, Month))

and maybe create a new field in the load script for that.

[sunny_talwar]

Are you using this on the expression tab or general tab? You need this on the general tab of list box properties

[Anonymous]

Thanks for Reply Stefan,

But I would like to add that in list box properties I didn't have Dimension or general tab.

I M using list box wherein i used month which is in numeric format.

[sunny_talwar]

You need to use it here

[Anonymous]

Thanks Sunny for reply,

In list box where I used this formula.

General Tab? where

[Anonymous]

Thanks Sunny,

[sunny_talwar]

No problem....