How to filter 2 criteria in data field in expression?

[#1]

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

[tresesco · Accepted solution]

try like:

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

Update: PFA

[#3]

Perfect! Thanks