Percentiles

[merlyn383]

How does one automatically do percentiles in FM? I'm dealing with a significant amount of data (up to 750 records and possibly 18 separate percentiles for each record). Also, to make matters more complicated, not every record in the file should be compared for all percentiles.

Example: 2 sections of the same class, i want to compare student X's performance in section 1 with the rest of the student's in section 1, but not to any student's in section 2, and vice versa.

Is this possible (considering the section constraint)? If not, how do i do it without the constraint?