1 Reply Latest reply on Apr 11, 2015 2:15 PM by raybaudi

    Calculation to find the sum of two columns that only contain a balance

    gremlin9297

      Title

      Calculation to find the sum of two columns that only contain a balance

      Post

      Greetings everyone,

      Im looking for a calculation that will find the sum of two fields and equal a third. Ah but there's a catch! I only want to add the records that are greater than 0.  So basically something like A > 0 + B > 0 = C. 

      Hopefully there is a somewhat simple solution.

      Thank you!