Forum Discussion

hale's avatar
hale
Helper II
3 years ago
Solved

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

  • 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's avatar
      hale
      Helper II

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