4 Replies Latest reply on Feb 25, 2016 2:21 PM by nicky.crooks

    Table calculations and colour dependent on value



      I have a text table which lists customers down the left had column and had a date field at the top, filtered to only include Mondays.  The measure is 'volume of data' so the table shows the volume of data for each customer on each Monday.


      I need to know the percentage increase of the volume of data week on week so I have created a Table Calculation to show the percentage difference between the current and previous week and added this to the table.


      All good so far :-)


      However, I know want to colour code the Table calculation percentage difference fields so that growth of over 10% is red, reduction of over 10% is green and everything else is black.


      Please can you tell me how I can do this?  I have created IF statements previously on colour, but cannot see how I can do this for the Table calculation.


      Many thanks.