7 Replies Latest reply: Feb 21, 2012 9:42 AM by Rajesh Vaswani RSS

    Need help on conditional formatting

      The report has one dimension brand and one expression Sum(Sales). Average of total sales should be displayed on the reprot as Total. And the background color of sales should be based on the following conditions.

       

      If(Sum(Sales)>=19000,RGB(0,127,0),If(Sum(Sales)<=4500,RGB(255,0,0),white()))

       

      These conditions have been specified in the expression background as below. The background colors for brands are according to the given conditions but not the Total row as below.

       

      QV.jpg

      The background colors for brands are according to the given conditions but not the Total row as below.

       

      Please help me on this so that Total background color should be according to the given conditions.

      Please find attached for the sample application.

      Thank you.

      Regards,

      kmiryalapl.