Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Get Started with Redwood for Oracle Cloud HCM Begin Now
Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Including latest requisition comment into reporting
Content
Hi Community!
I am trying to bring the latest comment against a requisition into a report - I can find the comments and the dates of the comments, but am finding it a challenge to bring back only the latest comment.
I have created a "days between" count between the comment date and the current date (C: days since last comment) - but when I do a "Min" on this for "Each Requisition" it continues to bring back all the days between counts and not the minimum for the requisition.
=Min(([C: days since last comment])ForEach([Requisition NO & Title (ML)]))
0