Conditional formatting with icons rule issue

[hale]

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

[amitchandak · Accepted solution]

@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

[hale]

oh thanks. It works now. That is quite confusing 🙂