Forum Discussion

Fusilier2's avatar
Fusilier2
Helper V
9 months ago
Solved

Help with icon conditional formatting settings

Hi,

I have this rule set up :

 

However, for some reason, I currently have a value which is 0  (I've checked and it is 0 with no decimals), but the above is showing the red arrow icon in my report instead of the amber icon.

Can anybody see anything wrong in my logic above?

Need Help
  • Fusilier2's avatar
    Fusilier2
    9 months ago

    Apologies everybody. I hadn't filtered the visual properly. I have done so now and all is working fine.,

6 Replies

  • KarinSzilagyi's avatar
    KarinSzilagyi
    Super User
    9 months ago

    Hi Fusilier2, that looks correct to me. Could you share an example showing a few rows of your table with the actual values used for the conditional formatting next to the icons? (You can crop out any other columns in the image.)

  • Fusilier2's avatar
    Fusilier2
    Helper V
    9 months ago

    This is the data the rule is evaluating (October - September)

    30/09/2025422.0
    30/09/202523.0
    30/09/202515.0
    30/09/2025100.0
    30/09/2025100.0
    30/09/202546.0
    30/09/202529.0
    30/09/202527.0
    30/09/202519.0
    30/09/20257.0
    30/09/20252.0
      
    31/10/2025418.0
    31/10/202523.0
    31/10/202516.0
    31/10/202599.0
    31/10/2025102.0
    31/10/202546.0
    31/10/202529.0
    31/10/202528.0
    31/10/202519.0
    31/10/20257.0
    31/10/20253.0

    Both months add up to 790

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    9 months ago

    Hi Fusilier2 

     

    What field are you applying this formatting to?  It appears to be called . and if it is numeric then you should also have a Summarization option which you can see in this example image is Sum 

     

     

     

    Is the data in the column you are trying to apply the formatting to numeric or is it text?

     

    Regards

     

    Phil

  • Fusilier2's avatar
    Fusilier2
    Helper V
    9 months ago

    Apologies everybody. I hadn't filtered the visual properly. I have done so now and all is working fine.,

    • PhilipTreacy's avatar
      PhilipTreacy
      Super User
      9 months ago

      Fusilier2 

       

      Not sure how filtering would affect CF rules, can you explain please?  The CF rules should be applied regardless of any filters.

       

      Phil

       

      • Fusilier2's avatar
        Fusilier2
        Helper V
        9 months ago

        I am using the CF rules with a measure calculation which is this month - previous month

        There are visuals for different departments so obviously I need to filter to the relevent department for the CF to reflect the correct calculation.