List Box Expressions and Search Abilities

[#1]

All,

I created an expression within my "YEAR" listbox that says if(YEAR>=2012, YEAR) - this works and still allows me to use the search icon as needed. When i created a similar expression within a SERIES listbox that says if(sum(NETSALES>0,SERIES,SERIES) - it would not work if i only had 1 SERIES like the first formula. Whenever i tried to initially search within series using the search icon, it would not allow me to until i changed over to "wildcard" setttings. Now it will not allow me to "select Excluded" - any ideas?

thanks for your help,

Parrish

[alexandros17]

If you use expressions (like yours) in the list box "select Excluded" will not be allowed, besides, that expession cannot work,

try, in the script to set a flag where Netsales > 0 for each row than use that flag in your above expresison