Cell comparision in WEBI report table

[Former Member]

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

[former_member210032]

Hi Shreyas,

What is 'i' in the FLAG condition.

Thank you

Mustafa

[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

[arijit_das]

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)))

[Former Member]

Thanks Arijit. Let me try and will get back to you.

[Former Member]

It working good..thank you:)

[former_member210032]

Hi Shreyas,

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

Thank  you

Mustafa

[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