Fractile and if

[helen_pip]

Hello

I was able to use Median and If in the same statement and get the function wokring O.K

MEDIAN

(IF([adm]=0,[Total]/1440))

However I cannot get the function to work with Fractile

  fractile(If([adm]=0, [Total],0.95)/1440)

Can someone kindly help me write the correct function for a FRACTILE(IF statement

Many Thanks

Helen

[swuehl · Accepted solution]

Try

  fractile(If([Patient Admitted?]=0, [Total Wait]),0.95)/1440

(moving one closing bracket around)

[helen_pip]

Thank you!  Works perfectly

[#4]

Please help me.

I have exam data of a class of 50 students.

Now I want to calculate the average (and, median) of top 80% students of that class.

How can I do that?
Please help.

Thanks.