Forum Discussion
Conditional formatting with icons rule issue
Hi all,
I am trying to set up an icon rule for the margin % of my report. If I dont change the default rule, the icons seem to display correctly, however, when I change to my rule, the icons just become all green, which is weird.
Anyone come across this so far. Profit Margin % is a measure which divide the sum of profit vs sum of revenue. Not sure if I miss anything, this seems to be a simple set up but somehow I still manage to not pull it off. Below are the 2 screenshots of the set up rule, first one is my custom rule and the 2nd one is default rule, I only change the value of each rule.This is what happens with my custom rule
seems to be working with default rule
hale , Make all those percentage as a number. % here means the distribution of values
ANd give value like
0 to .33
.33 to .67
.67 to 1
2 Replies
- amitchandakSuper User
hale , Make all those percentage as a number. % here means the distribution of values
ANd give value like
0 to .33
.33 to .67
.67 to 1
- haleHelper II
oh thanks. It works now. That is quite confusing 🙂