how to display all countries names in the list box without one specific city?

[#1]

could u please help with this question?

[vardhancse]

in list box->properties->General->Field->Expression(Instead of direct field)

=if(Business='Mumbai',Business) then it will display only mumbai others will not be displayed

[vardhancse · Accepted solution]

We can deselect not required values like using =if(Business<>'mumbai',Business) so except mumbai all the values will be displayed

[amit_saini]

Sri,

Can be done in two ways:(Suppose want to show all countries except Poland)

Script Side :

....

FROM

[.....

Where Country <>'Poland';

Front Side as Calculated exppression:

=if(Country<>'Poland',Country)

Thanks,
AS

[MarcoWedel]

‌please provide sample data and expected result.

regards

Marco

[#6]

awesome sasi...i got it. thank u for ur answer

[vardhancse]

Can please mark it as correct answer, so that it might helpful to some one.