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.
Combing Two Rows into One Based on Person Number
Hello everyone,
We're working on the earnings report and there are some employees have two assignments for one year. We are looking for the solution to combine them into one row (Or maybe we can say group rows based on 'Person Number'?). Here are the details:
We use employee 101360 as an example, he has two assignments during that year, second is the latest active one. We hope can add two numbers in 'Absences', 'Imputed Earnings', 'Supplemental Earnings' and 'Total Earnings' together and use the latest date in column 'Hire date', 'Relationship start date' and 'Termination Date'. Column 'Person Number' and 'Display Name' are always the same.
Tagged:
0