I would like this equation translated into Set Analysis. This should be fairly straight forward but all the examples show X field is equal to 'X, X.' I am unable to find the correct syntax for an if statement with a comparison.
If today’s < greater than the assigned to date count the number of tickets regardless ofany other selections.
I am attempting to show how many tickets were opened on todays date. So assigned date for each ticket. I converted =num(assigneddate) AS ASSIGNEDDATE_NUM. vToday is also defined in my load script as a num value. See both text boxes below to view values. TICKETID is just as the name applies.