I want to show the PIC name only in the list box excluding '-' blank

[#1]

Month	Vendor	PIC
Sep	ABC Vendor	Verma
Oct	xyz ltd	Mishra
Sep	sdfadsf ltd	Gupta
Aug	CRONOS CONTAINERS	Yadav
Oct	AMPORTS	-
Nov	ARTURO IBARRA A	-

[sushil353]

Hi,

Use expression in listbox. and give condition like if(len(PIC)>1,PIC)

Please find attached.

HTH

Sushil

[Anonymous]

Hi Partap use this  '=if(aaa<>'-',aaa)'  expression in the list box Field expression in general tab

[#4]

Thanks Sri.....

[#5]

thanks sushil