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.
