2 Replies Latest reply on Jun 21, 2012 11:15 AM by Tim Lens

    Calculating % of students in each quartile - Bottom two quartiles below x-axis

    Cole Pacak

      I'm trying to calculate the % of students in each quartile and put the bottom two quartiles below the x-axis.

       

      Without bothering with the x-axis, this wasn't hard. I put [Number of Records] in Rows and selected "Percentage of Column" under the Analysis tab.

      quartile 2.png

      Next, I was able to calculate the # of students in each quartile and put the bottom two quartiles below the x-axis using the calculated field [Counts by Quartile]:

      IF [Quartile] <= 2

          THEN [Number of Records] * -1

          ELSE [Number of Records]

      END

      quartile 3.png

       

      However, if I select "Percentage of Column" again, it goes haywire because of the negative numbers in the bottom two quartiles (they throw off the denominator).

       

      Any suggestions? A sample file is attached.