Forum Discussion
LakshmiSree
6 years agoFrequent Visitor
Conditional formatting is not working for decimal data type and % format
we are importing the data from excel with few calculated columns like Reliability, Margin Confidence, Quality and Revenue. Built the table visual based on those columns and choose AVG aggregation on...
az38
6 years agoCommunity Champion
Hi LakshmiSree
first, I see a hole in your statement.
values between 60 and 61 and values between 80 and 81 will not be affected by conditional formatting rules
second, how do you get a column "Average ofCTC Reliability (%)" on screenshot? is it a measure (if yes, show a formula) or just aggregation in visual?
do not hesitate to give a kudo to useful posts and mark solutions as solution
LakshmiSree
6 years agoFrequent Visitor
That is not a measure. "CTC Reliability" is the column and applied the AVG on the table visual field.