3 Replies Latest reply: Aug 10, 2013 2:24 PM by adadadad RSS

    Fractile and if

    Helen Pippard

      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