Selection

[smilingjohn]

IF(sales > 0 ,1, 0)

i have a layout condition for a list box as mentioned above , and within this condition a fielname called brand

and the brand is equal to 'TV'  it should hide . how do i acaive this . and it should enable when brand is eaul to others ?

and similarly there is one more condition for the layout which is

IF(

(

  sales

) > , 0, 0,1)

and within this also i want to include brande = TVS and it whould hide when tvs is selected and should enable if other brand is seleted .

[vinieme12]

=if(wildmatch(Brand,'TV'),0,1)

[hemachandran]

HI John

         In the listbox which field you are giving..

I guess you expecting this kind of answer...

in layout

if(sales >0 and brand='TV' ,0,1)