Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I change the text colour to red in two of the rows in the following table -
I would like to always highlight the 'Distance Learning', and 'Other open...' rows in red text.
Thanks
Greg
Using an if statement...
If(WildMatch(DimensionName, 'Distance Learning', 'Other open learning*'), LightRed())
Use background color for your dimension. Did that not work?
I assume I would use the background colour on the dimension, but how do I change the text colour for just two of the rows in the dimension?
Thanks
Using an if statement...
If(WildMatch(DimensionName, 'Distance Learning', 'Other open learning*'), LightRed())
Use an expression like:
If(Match([Mode of attendance], 'Distance Learning', 'Other....'), Red())
Just adjust the field and conditions in the match to your requirements.
Thanks very much
Why isn't the 'Other open learning...' field showing as red text in the following table?
I think it is because the first data column in the table has no value for the 'Other open learning...' row, eben though there are values in data columns 2 and 3.
How do I fix it to always show red?
Thanks
Try unchecking 'Suppress Zero Values' on the presentation tab and see if that helps
Also did you Match or WildMatch? Can you share the expression you used?
Thanks , that worked but it replaced the '-' with'0'