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