Need to Ignore one Value in List Box

[#1]

Hi Friends,

I am Having a List box. I want to Ignore one particular Value. But it have to show empty cell.

Here In the above List box. It showing Target has 99% & 98%. It should not show 98%. but I need a empty cell

Can any one please help me on this Issue

Thank you,

Swarupaaa

[tamilarasu]

Hi Swarupa,

You can use listbox expression in this case.

=If(Target <>'98%', Target, '')

[Anonymous]

Just correcting it:

=If(Target <>'98%', Target, '')

[#4]

Hi Nagraj,

This is the output

[#5]

Hi BalRaj,

This is the Output if i use  =If(Target <>'98%', Target, '')

[tamilarasu]

Thanks Balraj. Hope you are doing good.!!!

[Anonymous]

Yepp...Hope you too

[Anonymous]

Check the attachment, its working in my case..

Could you share your sample qvw?