Base on value color change

[arulsettu]

hi

i am having value in straight table using expression like sum(amount) so result like this

amount

2500

2320

2210

2010

1980

1500

1504

based on the input box value it will bring the highest value in straight table.

now i want to show difference in color. for example red color means based on value the red color should be differ

please suggest some ideas

thanks

[arulsettu]

now the color is blue based on the value the blue should change like ligh tblue..lighter than before, lighter than before

[neha_sri]

Hi Arul

If I correctly understood your question you can do something like this.

In expression>BAckground Color, you can write your value and coressponding to that you can  give the color

=

if(amount<=1500,red(),if(amount>=2300,blue()))

Regards.

[arulsettu]

hi

thanks fore reply

i am having input box if enter 20 it will show highest 20 value. so the amount value will differ

[jagan]

Hi,

Try this expression

=RGB(Div(Sum(Amount) * 25, 255), 0, 0)

Hope this helps you.

Regards,

Jagan.

[robert_mika]

is this what you have in mind?

[arulsettu]

Hi Jagan

showing every row in same color

[arulsettu]

yes excatly

[jagan]

Hi Arul,

Please check the file attached it all showing in different colors for the numbers you have given, if your numbers are closer then you can't see much difference.

Regards,

Jagan.

[arulsettu]

hi

Amount is expression label name