3 Replies Latest reply: Mar 7, 2013 2:28 PM by Karthikeyan A R RSS

    Sum only when the sum of two rows is positive

    Gonzalo Bianchi

      Hi all..

       

      I have a table with this layout

       

       

      Id
      dateNum1
      Num 2Total
      1xx1011-1
      2xx14104
      3xx20614
      total


      18 (-1 shouldn't be sum)

       

      I want a table that only show the sum where num1 is greater than num2. The total would be the sum of that condition. Can this be achieved on any type of table?

       

      Thanks