1 Reply Latest reply: May 17, 2016 7:43 AM by Sunny Talwar RSS

    Color condition issue

    Amit Saini

      Hi Folks ,

       

      Below is my condition :

       

      if (sum(Act)<sum(AOP),lightred())

       

       

      This is user requirement to show data upto 1 decimal , but if I'm doing this , I'm getting red colors if Act = AOP

      but from the second picture this is clear than Act value is less than AOP and hence showing red numbers.

       

      How can I handle color based on format , just want to show upto 1 decimal.

       

      So in case of KHE "95.2%" should be black and not red.

       

      Thanks,

      AS

        • Re: Color condition issue
          Sunny Talwar

          May be this:

           

          If(Round(Sum(Act), 0.001) < Round(Sum(AOP), 0.001), LightRed())

           

          UPDATE: I am sure if Act and AOP are percentages or not, but the idea is to use Round() function here. To what place to round it to, you can decide based on your data (either 0.1 or 0.001)