How do i calculate different conditions in the rows of the table.

[#1]

I have a table , for eg:

Name Sales Revenues Status(Traffic lights)

A        100      200        (if sales> revenues - green) -----> a condition for traffic light

B         30        30         (if sales<revenues- yellow) ------> a diff condition....

How do i acheive the same???

Its a table with almost 15 Names and has differnent condition for each Status calculation.

[qv_testing]

Background color OR Text Color you can write condition like

if you have many condition use like this

if(sales>revenus, green(),

  if(sales<revenues, yellow(),

      if(sales=revenues, Blue(),

        if(sales >= revenus, color(),

         if( sales<=revenues, color(), elsepart color())

I think so, No other option, you can write like this........

[#3]

That is not the table i am working on .... that is just the sample data I posted.

And in status there will be only 2 values .. either 0 or 1 depending on the condition I give .

[qv_testing]

can you post sample application....

[#5]

these condition vary for each row(almost 15 rows)..

On which condition it is varying?

you need to write 15 if.. else conditions in edit expression

[#6]

For eg:

No.    Field1 Field2  Status

1        A         B       (if A>B , then 1 else 0)

2        C         D       (if C<D, or C=D, then 1 else 0)

3        E        F        (if E>F, or E=F, then 0 else 1) etc.....

.

.

.

15     Y          Z        (if Y>Z , then 1 else 0).

This is the format of the table i have got....