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.