Hi Celonis Community,

I’ve recently started working in PM and am faced with my first real challenges.

To answer complex questions of the process owner I would need to execute more complex calculations in Celonis. I’m unsure to which extent this is supported.

I’ve read through the functions documented in the help section and functions highlighted here but could not find any that provide what I’m looking for.

Is it possible to base a calculation in Celonis on a previously calculated column? An equivalent of what I’m trying to achieve might be subqueries in SQL.

I’m unable to go give insight into the process and will provide a much simplified example.

My activity table looks like this:

Based on this I can calculate a new table with the automation rate per CASE

In the following I want to use the calculated column, to base further calculations on it. Like:

OR

I hope this is understandable enough. I’m also positive, that there might be an easier way to achieve this, but I am curious, wether a powerful construct like subqueries in SQL exist in celonis.

My first idea was, that these kinds of calculations would be possible, if new calculations could be based on OLAP tables created in the analysis.

Best,

David