Forum Discussion

vijayvizzu's avatar
vijayvizzu
Helper III
5 years ago
Solved

conditional formatting icon set

Hi  I have applied simple Icon set CF on one my column in the matrix The rule was simple, if the value greater than or equal to Zero, then green Icon, else Red icon But still, it shows RED for zer...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi vijayvizzu ,

     

     

    Sorry missread it then the rules are:

    Greater than or equal to 0  - less or equal to 100

    Greater than minimum (or any negative value) - is less than 0

     

    Check result below:

     

     

     

    I'm using a column but the result is the same with a measure.

     

     

MFelix's avatar
MFelix
Super User
5 years ago

Hi vijayvizzu ,

 

You issue is that you have both syntax the same greater or equal than zero.

 

You need to have:

Greater than 0 less or equal to 100

Greater than minimum (or any negative value) and is less than 0

 

To have the minimum just delete the 0 from the field it automaticallly fills with minimum.

vijayvizzu's avatar
vijayvizzu
Helper III
5 years ago

Thank you for your reply, here in this case, i want to put Greater than or equal to Zero as Green icon, so its not working, please suggest

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi vijayvizzu ,

     

     

    Sorry missread it then the rules are:

    Greater than or equal to 0  - less or equal to 100

    Greater than minimum (or any negative value) - is less than 0

     

    Check result below:

     

     

     

    I'm using a column but the result is the same with a measure.