Percentile Range

[alexismerinocue]

Hi everybody,

How can I calculate the percentile range for an employee? Due to his category, month and year. I mean, I have the next calculation for percentile,

num(fractile(aggr(sum({<Ejercicio=p(Ejercicio),[Mes Contable]={'<=$(vMesActual)'}>}[Salario Actual]) / ($(mNumeroEmpleadosEvolucion)),[Categoría Profesional],Empleado_id,Ejercicio,[Mes Contable]),$(vValorPercentil)),'#.##0'))

Where $(vValorPercentil) is an input field to calculate the percentile.

But now the customer wants to calculate what is the range percentile for this employee acording with his category, for example if the salary of this employee is 33.500 and the salaries of the rest of employees with the same category are 32.000, 48.500, 33.500, 40.000 the range percentile is 33,3.

Any help?

Regards

[Gysbert_Wassenaar]

Add the category to the set modifier in both the sum and the fractile aggregation functions.