List

[smilingjohn]

Hi All,

=IF(sales >  0, 0, 1)and IF(Brand='maruthi',0,1)

In a list box i have the above condition for in the layout ,

can someone explain what is this doing ?

[rahulpawarb]

Hello John,

Considering, you have used given expression in Show Conditional under the Layout Tab of List box object:

It will hide the List Box if Sales is greater than 0 and/or Brand has maruthi value (if both if statements true or any one of two is true). List Box will be visible to end users if both the If statements are false (Sales is less than 0 and Brand has value other than maruthi).

Hope this makes sense.

Regards!

Rahul

[nagarjuna_kotha]

If ur sales are Gretter than 0 and Brand is equal to Maruti, that object will be visible to you and rest of the conditions it will be in visible to you.

-Nagarjun

[smilingjohn]

hi Rahul ,

Thanks for the reply .

In brand i have

maruthi,

TVS

Bajaj.

=IF(sales >  0, 0, 1)and IF(Brand='maruthi',0,1)

SO my requirement is that whenever i slect maruthi brand the list box should hide  and for other brand it dhould show , so i have written the above expression .. it work work right ?

if TVS or Bajaj is selected in the brand this should display listbox.

[smilingjohn]

Nagaraju when sales are greater than zero this shoul hide .

[rahulpawarb]

John,

If Maruthi is selected and sales is greater than zero then below expression will hide the list box else it will show the list box for other brand values.

If(sales > 0 and Brand='maruthi', 0, 1) or If(Brand='TVS' or Brand='Bajaj', 1, 0)

Hope this will help.

Regards!

Rahul

[avinashelite]

did you check the text format of maruthi ? whether its maruthi and a space ? or Maruthi ?

share the app that will be easier to help you

[Anonymous · Accepted solution]

Hi John,

As you mention in ur post,

=IF(sales >  0, 0, 1)and IF(Brand='maruthi',0,1)

if both the conditions,sales is greater den 0 and brand is Marathi,than result will be 0(Hide),otherwise

if any of one condition won't satisfy than result will be 1(show).

R/Murali.