Skip to main content
Question

Filter for Cases which flow through a certain activity

  • February 3, 2020
  • 1 reply
  • 13 views
J
Level 3
Hi Celonis Community, I am currently analysing a P2P process where some orders have just been created, but not been ordered. These orders still have monetary values assigned to them in the Casetable. If I now add up the values to get how much money was spent e.g. on a certain article, these values distort my results, as they are also accounted for, but have not been ordered. Is there a way to restrict e.g. a certain table or sheet or the whole analysis to only values which run through the process step invoice received to only add up cases which have actually been ordered? E.g. with the Component-, Sheet- or Analysis-Filters? Thanks a lot. Best regards Jonas

1 reply

J
Level 0
  • justin.stegm
  • Level 0
  • February 10, 2020
Hi Jonas, you could apply the following filter as a analysis, sheet or component filter. It filters for cases which flow through the individual activity, e. g. Invoice received. FILTER PU_COUNT ( Case Table, Activity Table.Activity table Column, Activity Table.Activity Table Column with Activity Name = Your Activity ) > 0 Best, Justin
Community Code of ConductAccessibility statement