Date equality in count expression with variable

[shirleyc40]

Hi. I'm trying to count the number of customers with status = "pending"  and lastvisitdate = last business day. I have this expression: 

Count ({<applicant_status = {'Pending Mail'}, app_date = { $(lastBusDay) }>} distinct Customer_Number)

where lastBusDay =Firstworkdate(date#('7/26/2019')-1, 1) . But the expression above is not correct. How do I use a variable in a set expression?

[Kushal_Chawda · Accepted solution]

try with quotes

Count ({<applicant_status = {'Pending Mail'}, app_date = { "$(lastBusDay) "}>} distinct Customer_Number)