Multiple If Condition

[deepakkrish]

Hello All,

I have one table it has 4 columns , first column has all the table names second one is null values and third column is not null values.  I want to display led gauge based on some condition . see below is my table ..

Table:

Table	null	not null	led
Table 1	3	5	green
Table2	2	1	green
Table3	6	9	Red

condition for led :

if($Table='Table1', count(Table1.Name)>=2 and wildmatch(Table1.address,'Delhi','bangalore'),green(),

if($Table='Table2' , count(Table2.Name)>=5 and match(Table2.Pin,'123','456'),green(),red())))

how to write multiple if condition to show color for LED column?  Give me your ideas ,solutions .

Thanks in advance.

Krish.

[zhadrakas]

maybe this:

if($Table='Table1' AND count(Table1.Name)>=2 and wildmatch(Table1.address,'Delhi','bangalore'),green(),

       if($Table='Table2' AND count(Table2.Name)>=5 and match(Table2.Pin,'123','456'),green()

             ,red())))

[Brett_Bleess]

Deepak, did Tim's post help you get things working as you wished?  If so, be sure to come back and use the Accept as Solution button on his post to give him credit and let others know that did work.  If you are still working on things, please leave an update for us.

Regards,
Brett

[Surya]

Hello., Try This

if(wildmatch(Table,'Table1'),count(Name) >= 2 and wildmatch(Address,'Delhi','banglore'),Green(),

if(wildmatch(Table,'Table2'),count(Name) >=5 and wildmatch(Pin,'123','456'),Red()))