Hi @steven.bernd,

I think a Case When statement is the simpliest solutions:

TRIMMED_MEAN(

• Case
  • When "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-S%'
  • THEN CALC_THROUGHPUT(FIRST_OCCURRENCEC<%=Process_Start_1%>] TO LAST_OCCURRENCEC<%=Process_Start%>], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)
  • ELSE NULL
• END), 5, 5)

Normally aggregation functions ignore null values, which would solve this issue. Hopefully this helps!

Kind regards,

Jan-peter

Thank you very much. But it doesn't work.