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

[stabben23]

[stabben23]

No, I have 10 texobject.

[stabben23]

One of this textbox shall be green, the other ones red.

[tresB]

Staffan,

I have not got yet the logic of yours; how do you get the values account wise in text boxes if it is not hardcoded?

[stabben23]

Hi tresesco,

You are right about that, the values is hardcoded, but that is not the case here. I have

sum({$< Account ={'10'}>}Value) for ex in the expression for textbox with value from Account 10.

The case here is to get the textbox with the highest value to change color. And I try to do that with backgroudcolor.

[tresB]

This?

=If( Aggr(Rank(Sum(Value)), Months) =1, lightgreen(), red())

[stabben23]

No, works in tables but not in the textobjects, all went red.

[stabben23]

Here is the file tresesco

[tresB · Accepted solution]

PFA

[stabben23]

tresesco, this is absolutly a possible solution and maybe the best. I dident "se" that I have to hardcode the Account inside the textobjects backgroundcolor. Do you think there is a way to NOT use the Account No in the expression?

Thanks!

//Staffan