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.
Days of Difference Between Requisition Created and Requisition Approval Requested
Summary
Formula QuestionContent
I am trying to figure out a way to calculate the difference in Days between Requisition Created and Requisition Approval Requested BY Req. Identifier when the following statements are true
1. Transaction Event Type equals to Requisition Created, Requisition Approval Requested
2. The earliest date of Requisition Created and the latest day of Approval Requested
Challenge: I don't know how to create a formula that could calculate the difference correctly while meeting two criterion.
Temporary Solution: I use MAX to sort out the latest date of "Approval Requested" in one column and MIN to sort out the "Created" date in a different column and do the calculation in Excel.
Tagged:
1