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

    Counting a value where value is a positive/negative number

    David Ryan

      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.