Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Do not show a value on a list box

Dears,

I have a list with lots of names, and I don't want to show only the name "000" how can I do it?


Then names are infinity, but only the name "000" can not be showed, neither included on the frequency formula.

How can I do it/

thanks

2 Replies
Not applicable
Author

Why don't you try with an  if ( fieldname <> ' 000 ' , fieldname)

erichshiino
Partner - Master
Partner - Master

On the list box, go to end of the field list. There choose <expression>

then you can write the expression

=if(name<>'000', name)

Or you could remove it on script

load if(name<>'000',name) as name ...

[did the concatenate work for you??]