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

[jagan]

Hi,

You can also use Expression Label name in square brackets, instead of direct expression.

Regards,

Jagan.

[arulsettu]

Hi jagan,

i use this in expression background color

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

every row in grey color

[robert_mika]

Maybe like this

Based on your data set

=if(sum(color)<>Above(sum(color)),rgb(above(sum(color))/10,0,0))

This will only

[jagan]

Hi,

Can you attach the sample file?

Regards,

Jagan.

[arulsettu]

hi

doing binary load around 500 mb size. any possible way to upload

thanks

[arulsettu]

hi

it showing values in negative(wrong values)

[arulsettu]

this is my expression in straight table

amount:

=(sum({<CLM_TRANS_ID={"=CS_CLM_TRANS_ID"},CS_SETL_DTYear={$(vCurrentYear)}, CS_EST_TYPE={1}>}CS_AMT_LC_1)

-sum({<CLM_TRANS_ID={"=CS_CLM_TRANS_ID"},CS_SETL_DTYear={$(vCurrentYear)},CS_EST_TYPE={3}>}CS_AMT_LC_1))

-(sum({<CLM_TRANS_ID={"=CS_CLM_TRANS_ID"},CS_SETL_DTYear={$(vCurrentYear)},CS_EST_TYPE={2}>}CS_AMT_LC_1)

-(sum({<CLM_TRANS_ID={"=CS_CLM_TRANS_ID"},CS_SETL_DTYear={$(vCurrentYear)},CS_EST_TYPE={4}>}CS_AMT_LC_1)))

[robert_mika]

You can play with the RGB criteria

rgb(above(sum(color))/10,100,200)

Thi is not ideal solution as let say shades of blues in RGB are spread among many numbers

[arulsettu]

i will post the app please wait

[arulsettu]

i dint get exactly