4 Replies Latest reply: Dec 5, 2013 4:32 PM by David Ryan RSS

    Counting a value where value is a positive/negative number

      Hey Guys,


      Wondering if anyone can help. I am trying to create an expression if possible that is a sum of a field in my table loaded. But if possible i only want to count 1 in the value in the table is positive. I have both positive and negative numbers in my table.


      I thought it might be as simple as:


      if(num1 > 0,NumericCount(num1),0)


      Any help is much appreciated, Thanks.