Hi Masha,
my approach would be the following:
CASE WHEN ACTIVITY_TABLE.ACTIVITY_EN IN (remove billing block)
THEN CASE WHEN ACTIVITY_TABLE.USER_TYPE =A THEN USER TYPE A
WHEN ACTIVITY_TABLE.USER_TYPE =B THEN USER TYPE B
ELSE USER TYPE NOT KNOWN
END
END
This PQL-Formula selects the cases where the activity remove billing block is part of the process. After selecting these cases, the PQL-Formula then checks the user type and adds a dropdown option accordingly.
Best regards,
Data Science Team

---

Thanks a lot!
I actually already solved this one like this:
CASE WHEN _CEL_O2C_ACTIVITIES.ACTIVITY_EN LIKE remove billing block
THEN _CEL_O2C_ACTIVITIES.USER_TYPE
ELSE not relevant END
But thanks for your response anyway, it helped me to verify that I found the right solution. Im just learning to use celonis:)
Regards,
Masha

---