Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to add a conditional expression to a field in my straight table so that the background colour will be orange if the Status = Leaver.
I am attached my progress with this so far...
Any help would be much appreciated!
Thanks
Dilpreet
I have solved it - the transparency was 100%!
what is the exact issue you are facing? you expression seems correct..
it will apply only to one cell. if you it for all cells, add same condition in all fields
Maybe this:
if(aggr([Status],Level)='Leaver',RGB(235,100,30),White())
It doesn't seem to be working?
Yes, I only want the colour to change in one cell.
Thanks
Dilpreet
the only reason I can think of is, Leaver either has different case or has additional spaces, maybe apply trim
I have solved it - the transparency was 100%!