Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Why don't you try with an if ( fieldname <> ' 000 ' , fieldname)
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??]