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.
Unable to get Min and Max values in Compensation OTBI
Summary
We are struggling to use the min and max function to get proper valuesContent
Hi folks,
Trying this channel and hoping to find some help and support from customer or Oracle friends .
We are building on OTBI report on compensation provide to our users indicators that will help them to follow up their compensation calibration campaign.
We targeted to build the report below :
|
Gender |
Eligible Employees |
Total Eligible Salaries |
|
|
|
2020 Estimated Bonus Payout incl. Group Score |
|
||||
|
|
|
|
Total |
Compensated Employees |
Average |
Low |
High |
|
|||
|
F |
10 |
200000 |
10000 |
5 |
2000 |
500 |
7000 |
|
|||
|
M |
5 |
100000 |
5000 |
2 |
2500 |
1000 |
1500 |
|
|||
We were able to build everything except the min and max column which is giving us the total compensated amount min and max by gender
Tagged:
0