Hi, Everyone! I have another question regarding AF. How can I combine the POs by Sales Rep and send all of the PO’s related to that person in one table/email? I tried to create a text aggregator and applied variables, but it's not working..
Page 1 / 1
Thanks for posting.
There are following modules to generate a query from your data model.
https://docs.celonis.com/en/query-data.html
https://docs.celonis.com/en/get-rows.html
Please try these modules to generate your required tables.
You can also try the "Create PDF report" module if you already have an analysis sheet.
https://docs.celonis.com/en/create-pdf-report.html
Thanks for your understanding.
There are following modules to generate a query from your data model.
https://docs.celonis.com/en/query-data.html
https://docs.celonis.com/en/get-rows.html
Please try these modules to generate your required tables.
You can also try the "Create PDF report" module if you already have an analysis sheet.
https://docs.celonis.com/en/create-pdf-report.html
Thanks for your understanding.
Hajime Shimmen Do you know which filter I can apply in PQL to give me only the orders with more than 90 days in the end of the current month?
Thanks for your reply.
I am afraid that I don't have a straight answer.
However, PQL has various datetime functions.
https://docs.celonis.com/en/datetime.html
I think it is possible to calculate the difference between the end of the month and the order date using a combination of TODAY(), DAYS_IN_MONTH(), etc.
I am afraid that I don't have a straight answer.
However, PQL has various datetime functions.
https://docs.celonis.com/en/datetime.html
I think it is possible to calculate the difference between the end of the month and the order date using a combination of TODAY(), DAYS_IN_MONTH(), etc.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.