1 Reply Latest reply on Mar 9, 2016 5:46 PM by Adam Crahen

    Conditional Coloring - Column Values, Not Totals

    Eric Horio

      With the help of Adam and Pooja ( Thanks to you both! ) they were able to show me how to color code a particular column only ( Pipe Created ) with a value threshold:

       

      IF ATTR([Stage]) = 1 AND SUM([Pipe Created]) >= 2000

          OR ATTR([Stage]) = 2 AND SUM([Pipe Created]) >= 1500

              OR ATTR([Stage]) = 3 AND SUM([Pipe Created]) >= 1000

              THEN "Green"

       

      Now my question is, how can I get it to not color code the subtotals or grand totals? I'm only interested in the individual amounts.  Any suggestions?