Hi,
I am facing an issue while getting the number of iteration of the activity purchase requisition before the activity purchase order.
if anyone have idea how can we get the activity occurrence so please help!
Thanks in advance.
Page 1 / 1
Hello,
You can try to use INDEX_ACTIVITY_ORDER funtion, with remap_values to get order of all activities. I would remapped all unwanted activities to NULL which would be then ignored by Index function.
Example: INDEX_ACTIVITY_ORDER ( REMAP_VALUES ( "Table1"."ACTIVITY" , , 'A' , NULL ] ) )
Link 1: <your celonis link>/help/display/CIBC/INDEX_ACTIVITY_ORDER
Link 2: <your celonis link>/help/display/CIBC/REMAP_VALUES
Let us know it that helped.
Best Regards,
Mateusz Dudek
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.