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.
OBI - Latest Req Transaction Date
Summary
OBI - Latest Req Transaction Date formulaContent
I have a report in OBI. The Requisition history transaction dates can pull MANY rows. What I'm looking to do is filter "Req History Transaction Date" ONLY to the most recent.
I tried adding a filter (and converting it to SQL), which displays: ("Requisition Tracking History"."Req. History Transaction Date" IN (MAX("Requisition Tracking History"."Req. History Transaction Date")))
It appears it's not working, it's still pulling numerous requisition history transaction dates, not the latest one.
I'm so close, but not close enough
Any suggestions?
Don
2