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 30The 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
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)))
Hi Shreyas,
What is your exact requirement explain clearly........?
Thank you
Mustafa
Hi Shreyas,
What is 'i' in the FLAG condition.
Thank you
Mustafa
Add a comment