Value greater than below

[#1]

Hi All,

Please help me for the requirement which I have.

Please find the attached application.

I want the background color of row as green which is greater than row below it.

For eg. In attached qvw

1) First Row 155 is greater than Row below which is 123 , so background of 155 should be green.

2) Now for Row no 3 i.e value 110 which is less than the row below it .ie 119 , background of row 110 should be red.

[#2 · Accepted solution]

Hi,

You can try the function Above in the background color of the expression.

So you could use something like this:

=if(avg(Result)>Above(avg(Result),-1),green(),red())

Hope that helps.

[its_anandrjs]

Hi,

Use some thing like this in Background color expression

if(Above(avg(Result)) > Below(Avg(Result)) ,Red(),Green())

Regards,

Anand