2 Replies Latest reply: Oct 31, 2018 12:55 PM by Rob Wunderlich RSS

    I know this is easy but....

    andy whitfield

      I want to apply a conditional background colour to the following expression in sense:

       

      ((Sum({<month_id={$(=Max(month_id))},dm_complaints_number={'B23'}>}dm_value)-Sum({<month_id={$(=Max(month_id))},dm_complaints_number={'B23'}>}dm_previous_month_value))

      /

      Sum({<month_id={$(=Max(month_id))},dm_complaints_number={'B23'}>}dm_value))

       

      it calculates the percentage change between 2 columns if its less than .25 then green, more than red.

       

      I know this is an easy if statement, but can't get it right!!

       

      Cheers folks

       

      Andy