Hi,

I wanted to implement the open target quantity in celonis. Therefore I used the RUNNING_TOTAL function to add up the quantities as shown in the screenshot.

After, I wanted to subtract the RUNNING_TOTAL from the target quantity, the code for this looks like that:

"CONTRACT_INFO"."KTMNG" - RUNNING_TOTAL("EKPO"."MENGE")

That constantly gives me the following error:

The running aggregation function RUNNING_TOTAL cannot be used together with a dimension function input. Please check that there are no moving aggregations and dimensions used together as function inputs.

Even if I try to use e.g. AVG(), SUM(), LAST() in front of "CONTRACT_INFO"."KTMNG" , it's not working.

Only if I use RUNNING_TOTAL() in front of "CONTRACT_INFO"."KTMNG" it's working, but obviously this is giving me wrong results.

Thanks for your help.