3 Replies Latest reply: May 10, 2013 1:25 AM by Byron Van Wyk RSS

    Greater than logic on Pivot Table

      Hey Developers - I have a problem

       

      I need to be able to change the background colour if the participation rate on the week / month post the previous week / month is greater in green or red if below.

       

      Cannot seem to get the expression right ?

       

      Any help will be much appreciated

       

      Using : =If( Column(0)>Column(1), LightRed(), Green()) at the moment.

       

      image002.png