Continuing the discussion from Greetings!:
Hi
Im new to Celonis and i have a requirement in building an analysis. Below specified is the requirement.
I have configured a Button drop down and it display all the Activites list. I created a variable (<%= ACTIVITY_GROUP_1 %>) to save the selection from the dropdown. I want to calculate the selected Activity count.
Below is the formula im using to get the count and it giving me correct values only if i select a single Activity. When i select multiple Activities i can see the variable having all the selected Activities seperated by comma(,) but the result is 0.
Can someone help me in getting the count of multiple Activities, and below is the formula im using.
SUM(
PU_COUNT(CASE_TABLE, _CEL_AP_ACTIVITIES.ACTIVITY_EN,"_CEL_AP_ACTIVITIES".ACTIVITY_EN IN ( <%= ACTIVITY_GROUP_1 %>)))
Thanks & Regards,
Chanti
Page 1 / 1
Hi Chanti,
In the Button drop down, please ensure the wrapping character fields have single inverted commas included. See below image.
Also, modify your code to remove those inverted commas where the variable name is placed.
SUM(
PU_COUNT(CASE_TABLE, _CEL_AP_ACTIVITIES.ACTIVITY_EN."_CEL_AP_ACTIVITIES".ACTIVITY_EN IN (<%=ACTIVITY_GROUP_1 %>)))
Lastly, this may not give you an error, but not 100% sure if your function will give the correct answer either. But I wont be able to confirm or suggest otherwise without knowing more about the final analysiss objective you are trying to create.
In the Button drop down, please ensure the wrapping character fields have single inverted commas included. See below image.
Also, modify your code to remove those inverted commas where the variable name is placed.
SUM(
PU_COUNT(CASE_TABLE, _CEL_AP_ACTIVITIES.ACTIVITY_EN."_CEL_AP_ACTIVITIES".ACTIVITY_EN IN (<%=ACTIVITY_GROUP_1 %>)))
Lastly, this may not give you an error, but not 100% sure if your function will give the correct answer either. But I wont be able to confirm or suggest otherwise without knowing more about the final analysiss objective you are trying to create.
Hi Newlen,
Thanks for your prompt response and it solved my requirement.
Now i can able to get the count for the selected multiple activities.
Cheers!
Chanti
Thanks for your prompt response and it solved my requirement.
Now i can able to get the count for the selected multiple activities.
Cheers!
Chanti
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.