Formatting can also be done using conditions. Like in almost any current programming language, in CPM SAP Process Mining by Celonis conditions can be defined by using a modification of the IF … THEN … ELSE syntax. The expression can be read like this: IF the first value is true, THEN the option specified here will be executed ELSE the option specified here will be executed. A simple every-day life example would be: IF it is raining THEN I will stay inside ELSE I will go for a walk. How conditions can be used for formatting will be explained in the following sections.
IF (test; thenvalue; otherwisevalue)
In CPM SAP Process Mining by Celonis conditions are defined using a shortened form of the IF … THEN … ELSE expression as given above. Using this function, you can for example specify that if a value exceeds a certain test value then it should be shown in red and otherwise in green. This gives you a powerful option for making your analyses intuitively understandable and for immediately being able to identify critical values. You can even define formatting in finer granularity by adding another conditional expression to either the “thenvalue” or “otherwisevalue” parameter. More information about this option can be found in Nested Functions. An example for simple conditional formatting can be seen in Figure 3.22.
...