Skip to main content
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..
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.

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.