5 Replies Latest reply: Oct 5, 2012 5:42 PM by Mayil Vahanan Ramasamy RSS

    PLEASE help....

      How do I format an expression to say:

       

      Give the average of the numbers in a field if conditions X, Y, and Z are met.

      ABC
      201120120
      2010-1
      201120112

       

      I want to say give me the sum of column C ONLY for the individuals that meet the statement if A > 2010, if B <2012, and C is not (<>) 0.

       

      the 1st colum fails because C is 0

      the 2nd column fails because A is not > 2010

      The third colum passes since A is > 2010, B is <2012 and C is something other than 0 so I should get a returned value of 2

       

      Is there a way to write an expression that gives you the value for a column for only hte rows that meet the conditions?