Skip to main content
Question

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..

  • November 21, 2023
  • 3 replies
  • 2 views

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..

3 replies

Forum|alt.badge.img+5
  • Level 0
  • November 24, 2023
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.

  • Author
  • Level 7
  • November 30, 2023

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?

 


Forum|alt.badge.img+5
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.