2 Replies Latest reply on Jul 26, 2018 10:49 PM by kumar.c

    Negative numbers are in red for multiple measures.

    Ranjan K T

      Hi All,

       

      I have a sheet with multiple measures and i just wanted to show the negative values are in red and all the positive numbers in black.

       

      I have tried using the below expression. but i Couldn't achieve what i wanted for all the columns.

       

      if([GTER Growth %])>0 THEN "RED" else "Balack" END

       

      Is there any condition which makes all the measures shows the negative numbers are in red.

       

      please let me know if some one can help me on this issue?

       

      Thanks,

      Ranjan