2 Replies Latest reply: Aug 27, 2013 4:55 AM by Mildred Moral RSS

    How to filter 2 criteria in data field in expression?

      Hi,

       

      Its me again.. sorry i'm new to QV..

       

      I'm trying to add a code in the expression to filter two criteria "New" and "Under Clarification"..

       

      I have a Straight Table  and i want to get the data only the status (field) is "New" and "Under Clarification" without selecting it in the List Table

       

      I added this to my expression {<status = {'New' & 'Under Clarification'}>} but it is not working properly

       

      here's my code

      =count( {<status = {'New' & 'Under Clarification'}>}  {$<[Request Received] = {">=$(=Date(Today()-5))"}>} DISTINCT [Request Received])

       

      Attached is my sample report

       

      Thanks