Former Member

# Cell comparision in WEBI report table

Hello Guys,

How to compare value of each cell in a column of a table?

For example:

SUBJECTS MARKS FLAG A1 12 1 A2 42 2 A3 20 1 A4 30 3 A5 30

The FLAG variable works like this.

If Marks[i] > Maraks[i+1] then FLAG=1

If Marks[i] < Maraks[i+1] then FLAG=2

If Marks[i] = Maraks[i+1] then FLAG=3

Need your help here on achieving this. Thanks a lot for your help.

Shreyas

10|10000 characters needed characters exceeded

### Related questions

• Posted on May 12, 2014 at 10:42 AM

Use the formula below:

FLAG =If([MARKS]>RelativeValue([MARKS];([SUBJECTS]);1);1;If([MARKS]<RelativeValue([MARKS];([SUBJECTS]);1);2;If([MARKS]=RelativeValue([MARKS];([SUBJECTS]);1);3)))

10|10000 characters needed characters exceeded
• Posted on May 12, 2014 at 10:15 AM

Hi Shreyas,

What is your exact requirement explain clearly........?

Thank you

Mustafa

10|10000 characters needed characters exceeded
• Former Member

Hey Mustafa,

I need a column called FLAG which shows the values 1/2/3 depending on comparing values of marks[i] row and marks[i+1] row.

Thanks

Shreyas

• Posted on May 13, 2014 at 12:16 PM

Hi Shreyas,

What is 'i' in the FLAG condition.

Thank you

Mustafa

10|10000 characters needed characters exceeded
• Former Member

Hey Mustafa,

Marks[i] is value in cells in Marks column. So iteratively i wrote it as Marks[i].

In simple programming terms:

Marks[0]=12

Marks[1]=42

Marks[2]=20

Marks[3]=30

Marks[4]=30

Thanks

Shreyas