Forum Discussion
Conditional Formatting not working on all rows
This issue came up again recently when the customer asked to see decimal numbers instead of whole numbers. The conditional formatting was again not applying to the correct condtions. For example, my calculated mesaure (deimal number) displayed 0.00 but the conditional formatting did not pick up on it.
Going back to d_gosbell statement about the foating decimal, I found that even though the calculated measure displayed "0.00", when I opened up the number of decimal places to 15, I found that true number to be "0.000000000400000". This stemmed from the two source columns used in the calculated measure, which were formatted as 'Decimal Number' in the Query Editor.
I changed the two source columns used in my calculated measure in Query Editor to Fixed Decimal, which solved my problem. All of the flaoting numbers in the Decimal format were removed and the condtional formatting applies correctly. Took me way longer to figure this out than I'd like to admit but I hope it helps others.
I finally discovered this is caused by some columns being set to somethign other than 'Don't Summarize'.
In circumstances where the columns to be summarized are blank, this causes an error, which somehow causes the conditional formatting to fail (even where the formatting is being done on another column). Clearly an error within the application.
SamiP wrote:
I finally discovered this is caused by some columns being set to somethign other than 'Don't Summarize'.
In circumstances where the columns to be summarized are blank, this causes an error, which somehow causes the conditional formatting to fail (even where the formatting is being done on another column). Clearly an error within the application.
I just tried to reproduce this and I cannot, the conditional formatting works fine for me regardless of the presence of any blanks in an aggregated column. Are you able to reproduce this in an example file that you can share?