The records with Name = 6, 10, 23 are borderline and I am not sure if your percent decile ranking is using the same logic across the board. If 6 falls in 20% then 10 should be in 30% and not 40%. Does that sound good?
Most likely rounding logic will be needed to crank out those values:
I will attach the workbook once I am done with the condition for 50%.
Here is the final calculation for 50% mark:
In my example, only 3 accounts result into that mark. You can modify the names to suit your requirement.
Attached is the workbook with all calculations and as you review from left to right, you will see that each new calculation shows up.
If you have any questions, do let me know.
If it helps out, please mark the replies as helpful and answered.
Decil.twbx 35.5 KB