10 Replies Latest reply: Jan 25, 2016 12:04 PM by Sangram Reddy RSS

    How do I colour the background of negative Sales Variance numbers in a table

    Betty Habtemariam

      Hello everybody,

       

      I've been trying to colour the background of negative Sales Variance % in a table and it has worked in other tables before, but not this time. This is the table  where I want to colour the background red (Sales Variance%):

       

      Skärmklipp2.PNG

      The expression for Sales Variance % looks like this:

      Sum({$<Year={$(=Max(Year))}, Mon={$(=Month(Today()))}>}Sales)/

      Sum({$<Year={$(=Max(Year)-1)}, Mon={$(=Month(Today()))}>}Sales) - 1

       

      Can anyone tell me how I can write an expression that makes the colour in the background red?

       

      Sincerely,

      Betty Habtemariam