Forum Discussion
Conditional Formatting not applying as expected when using Percentages
It's quite a common misunderstanding this one. You can search the forum for solved similar issues.
Using 'percent' in conditional formatting is not about the data type, it's about
"the rule boundaries as a percent of the overall range of values" which you don't want in this case.
Use a different rule type as here:
"I'd also like to understand the phrase "the rule boundaries as a percent of the overall range of values" as I don't know what you mean by that and therefore don't really understand what was wrong." - that's not my phrase. That's in the linked article which has examples to explain this.
--
"what I need to show, ideally, is the count "full" as a % of the row total... Ideally it would be in an additional column so we have the count and the % but thats not necessary." - I thought that you managed to do that first part (in the original post) but it was the conditional formatting that you were having trouble with.
-
My initial response assumed that the measure you are using in the matrix had been formatted as percentage (or the datatype of the base field of the measure was a percentage) and, when using percent in the rules of conditional formatting this was giving unplanned results. Is this a true reflection of the problem or is it something else?
The number in each column is an integer, it is not formatted as a percentage. The matrix is a count of values with subtotals per business and per state and does this count itself, The data is a single column in a table that indcates the state of that asset one each row.
the raw data would look like this in its simplest form (obviusly there are other columns as well)
| Name | Enforcment State |
| asset 1 | full |
| asset 2 | selective |
| asset 3 | full |
| asset 4 | Idle |
| asset 3 | full |
| asset 4 | Idle |
Is this what you were asking