Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try with quotes
Count ({<applicant_status = {'Pending Mail'}, app_date = { "$(lastBusDay) "}>} distinct Customer_Number)
try with quotes
Count ({<applicant_status = {'Pending Mail'}, app_date = { "$(lastBusDay) "}>} distinct Customer_Number)