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 zero values. unable to fix it

 

 

 

  • 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.

     

     

3 Replies

  • 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

      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

        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.