Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=count(if(num(vToday)<num(ASSIGNEDDATE), (TICKETID)))
Let me know if you have any other questions.
Thanks.
I am:
Attempt 1:
=count({1<ASSIGNEDDATE_NUM={'vToday'}>} TICKETID)
Attempt 2:
=count({1<ASSIGNEDDATE_NUM={vToday}>} TICKETID)
This works if I do this: (but I would like it dynamic)
=count({1<ASSIGNEDDATE_NUM={'40948'}>} TICKETID)
'$(vToday)'
No need for if. Or youcan use if witout set. You have to use the example from Karl, but with
ASSIGNEDDATE_NUMcount({$<ASSIGNEDDATE_NUM={">$(vToday"}> TICKETID)
Thank you Federico and Michael. Both solutions work. Beleow is what I ended up using.
=count({1<ASSIGNEDDATE_NUM={$(vToday)}>} TICKETID)