5 Replies Latest reply: Jun 8, 2011 8:53 AM by tim_miles RSS

    How to exclude values where the % difference is zero

      Hi all,

       

      I'm a newbie so please bear with me ( I have searched to see if I could find an asnwer to this from the existing discussions ). I have a table where I calcaulate the % differences between two fields using a simple expression. What I'd like to do though is use either an expression, or setting in the table box that means ONLY those rows where the % difference between Field A and Field B is > 0%.

       

      It's for a reconciliation of 500,000 records where I only want to see those that don't match!

       

      Many thanks.

       

      Tim