5 Replies Latest reply: Jul 25, 2017 3:42 PM by Mary Jo Taft RSS

    color in table based on variable

    Robert Winkel

      how can you color   have multiple colors when using the Background color expression?

      Below is what I am trying with no luck.

       

       

       

      if(ActPkgCost/PurchPackSz<0.25, green(),

       

                    if(ActPkgCost/PurchPackSz>0.25, <0.50 Yellow(),

       

                    if(ActPkgCost/PurchPackSz>0.50, Red())))