Percentile calculation

[#1]

Hi All,

I need to calculate Salary range percentile for employees. How can this be achieved ?

Please provide me examples on this.

Regards.

[hic]

Fractile( Salary, 0.75 )

will calculate the 75% fractile of the field Salary.

HIC

[settu_periasamy]

Hi,

Like this..?

SAL:
LOAD *,Num((Sal_Off_Min_Diff/Max_MinDiff)*100,'#,##0.00') as Percentile;
LOAD *,
  [Max Salary]-[Min Salary] as Max_MinDiff,
  [Salary Offered]-[Min Salary] as Sal_Off_Min_Diff
 INLINE [
    Min Salary, Max Salary, Salary Offered
    76000, 95000, 80000
    34000, 45000, 43000
    36831, 55500, 40422
    77000, 94000, 78000
];

Result: