List box

[mario-sarkis]

‌hey all

i have a list box containt field name but in this field i have a "-"  but i dont want to show it

how can i show all the name of this list box except this "-"?

i Dont want to change the field in the script coz my use it for other calculation in the dashboard.

thanks

[sunny_talwar]

May be this as your list box expression:

If(FieldName <> '-', FieldName)

[mario-sarkis]

‌hi sunny no it didn't work it show another same column

[sunny_talwar]

Can you show a screenshot of what you are seeing?

[ali_hijazi · Accepted solution]

scroll down to expression where you can put if(your_field <> '-', your_field)

[mario-sarkis]

‌thank you ali, i thought sunny is telling have to do it in the expression tab not the drop down list

[sunny_talwar]

Is it working now? If it is, I would request you to close this thread by marking the correct answer.

Best,

Sunny