13 Replies Latest reply: Feb 9, 2012 2:50 PM by Jake Bingen RSS

    Set Analysis Count If?

      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.