hOW TO Restrict values in listbox?

[#1]

i have list box contains below values

fy 2001

fy 2002

fy

now i want remove 'fy' 

output

fy 2001

fy 2002

Thnks

[alexandros17]

In the list box instead of field use expression (is at the bottom of the fields list)

and write: mid(myField,3)

where myField is the field containing fy 2001 ...

[Gysbert_Wassenaar]

Try using an expression instead of the field name for the listbox: =if(MyField='fy',null(),MyField). Replace MyField with the name of the field you want to show in the listbox. If the value you want to suppress contains spaces you can try =if(trim(MyField)='fy',null(),MyField)

[Sokkorn]

Hi,

You can get your job done by using expression in your list box. I have two types. Let try

     1. =Aggr(Only({1<Field -= {'fy'}>} Field),Field)

     2. =If(Field='fy',Null(),Field)

Regards,

Sokkorn