2 Replies Latest reply: May 18, 2012 8:49 AM by GERMAN TORRES RSS

    SET ANALYSIS not working in correct way

      Hi All

      Im using this expresion into a text object:

       

      =Count({<STATUS_CALL = {7,8,9,10}, AÑO_FechaLlamadoOriginal = {"=year(today())"}, MES_FechaLlamadoOriginal= {"May"} >} distinct IdCallLlamadoOriginal)

       

      the idea its not to use like this because the idiea its to take the month of the current day. So, should be something like this:

       

      =Count({<STATUS_CALL = {7,8,9,10}, AÑO_FechaLlamadoOriginal = {"=year(today())"}, MES_FechaLlamadoOriginal= {"=month(today())"} >} distinct IdCallLlamadoOriginal)

       

      But it isnt working...

      I have tryed with month in number format, in name format and theres no way to make the MES_FechaLlamadoOriginal become equal to the Month.

       

      Whats the problem? I dont know what its going on, really.

       

      Thanks for All!

       

      Germán.