How to exclude items out of listbox with value 0?

[NashLena]

Hi all,

I'm fighting the following problem. I have about 3000 items in my listbox and many of those items give the value 0. What I want to do is to exclude the items which gives y=0. Does someone have an idea how to do this?

Thank you!

[rubenmarin]

Hi @NashLena, in the list box you have many 0 values? or many values that in your expression returns 0?

You can try with: =Aggr(If([YourExpression]<>0, FieldName), FieldName)

Not good for performance but with not many data it should work ok.