Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with set analysis

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

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

SM9.INCIDENTSM1.OPEN_TIME_NUM={'>41306'}

Add the condition to the others it have to work ...

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

SM9.INCIDENTSM1.OPEN_TIME_NUM={'>41306'}

Add the condition to the others it have to work ...

Anonymous
Not applicable
Author

Thank's a lot for your help, Alexandros!

It looks so simple when I see the solution.

Regard

Torunn