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
