12 Replies Latest reply: May 1, 2015 9:12 AM by Dan Maczko RSS

    greater than and less than

    Dan Maczko

      I have a column of $ values- both negative(-$14.27) ,Positive($14.27) and Balanced( $0.00).

       

      I want to do a Text Object to display the SUM of the Greater Than $0.00 and the Less Than $0.00.

       

      I am using this expression

      =sum(DIFFERENCE <'0') & (DIFFERENCE>'0')

       

      But it is only returning the SUM of the negative(-$14.27).  If I switch the order of the Greater and Less, it then will SUM only the positive.

       

      What would be the correct expression?

       

      Thanks!

       

      Dan