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

    How to filter 2 criteria in data field in expression?



      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