Conditional Formatting Straight Table

[khaycock]

Hey,

Is it possible to conditional format a row depending on another field? I have a Straight table where I need to colour a row depending on a specific field. So if Order Constraint is At Risk, I need the row to be yellow, if it is Blocked, I need it red and if its null, green.

What is the best way to do this, if possible?

Thanks

[Anonymous]

just set the color condition for every dimension

and expression

in use

[khaycock]

I've tried with an if statement but couldnt get that to work

[Anonymous · Accepted solution]

Hi

For your Constraint Count expression>Expand your expression>Background Color:If(OrderConstraint='At Risk',RGB(255,255,0),If(OrderConstraint='Blocked',RGB(255,0,0),RGB(0,255,0)))

Hope it helps!!

[Anonymous]

could you create a sample please...

My first guess is that the OrderConstraint isn't distinct within your dimension hierarchy...

Then you would get null() as return value...

But as I said, I need some sample data...