Change Background color on Rank

[stabben23]

Hi,

is it possible to change the background color that depends on the Rank Value.

In my example I have 9 account and I want to show them in separate textobject. The textbox included '1050' should in this case be green. Is it possible for the textobject to know about the dimension outside the object it self? The expression is sum({$<Account={'50'}>}Value)

//Staffan

[tresesco]

Ideally one should use fixed number of text boxes (may rank1 to rank5). Then you don't need to hardcode the accounts in the expression. but if you hardcode account in the sum() expression in the front end to show values, there would be no choice but to do the same in the background color expression as well.

[stabben23]

The Boxes are in an dashboard and they are fixed at the same place no matter what. I will implement your solution, Thanks again.

//Staffan