4 Replies Latest reply: Jun 29, 2011 6:44 AM by JennyHughes RSS

    Expression - Return result if figure does not equal zero

      I have a straight table that has a number of expressions which return numeric figures. On one of the expressions I need to filter out anything that does not equal zero. My current expression is Sum(Settled). What should my expression be to return: sum(settled), only if settled does not equal zero? The result would be that the straight table only shows results when the settled figure is not zero, regardless of what the other expressions return.Thanks.