2 Replies Latest reply: Feb 3, 2013 8:49 AM by Torunn Midtsjo RSS

    Help with set analysis

    Torunn Midtsjo

      Hi!

       

      I have the following expression with set analysis that works fine:

       

      =sum({$*SLA_PL<SM9.INCIDENTSM1.OPEN_STATUS={'closed'},SM9.INCIDENTSM1.CATEGORY={'SERVICEREQUEST'},SM9.INCIDENTSM1.SUBCATEGORY2={'Kunde'},SM9.INCIDENTSM1.RUB_SLA_DEADLINE-={'=$(=NULL())'}>}SM9.INCIDENTSM1.COUNTER)

       

      I need to put in one further condition, but have problems with the syntax.  I have a numeric date-field called  SM9.INCIDENTSM1.OPEN_TIME_NUM

       

      I need to put in another test that says that only records with  SM9.INCIDENTSM1.OPEN_TIME_NUM  greater than 1st Feb 2013 shall be included.  The numeric value of this date shall be 41306.

       

      How is the syntax in set analysis for testing that SM9.INCIDENTSM1.OPEN_TIME_NUM shall be greater than 41306?

       

      I am very grateful for any help with this set analysis.

       

      Best regards

      Torunn