Quartile based on actual salaries and not grade rates
Summary:
Hello Team,
I understand that Oracle’s quartile calculations are typically based on the minimum and maximum values of a predefined grade rates. However, I want to calculate quartiles based specifically on the actual salaries of employees who belong to a grade.
For example, if the grade salary range is from 5000 to 10000, but some employees have salaries below that range (e.g., 3000), is there a way to calculate quartiles using only the actual salaries of those employees within that grade, rather than the fixed min and max range? In this case the system is giving Below-Range.
If possible, could you please provide guidance or an example on how to achieve this?