2 Replies Latest reply: Apr 14, 2017 4:15 PM by Michael Andrews RSS

    Issue calculating quintiles (fractile function)

    Michael Andrews

      I'm getting some wrong numbers trying to calculate quintiles. Basically I have 5 columns 0%-20%, 20%-40%, 40%-60%, etc.

       

      And I'm trying to put the counts where ExamScores fall in those quintiles like so.

       

      Count({<ExamAggExamScoreRaw = {"< $(=Fractile(ExamAggExamScoreRaw,0.20))"}>} DISTINCT ExamID)

       

      I'm getting some bad counts so I was trying to just see what it was getting for the fractile of .2, but when I put

       

      Fractile(ExamAggExamScoreRaw,0.20) to output data, it gives me an error, what am I missing?