3 Replies Latest reply on Jan 9, 2014 11:50 AM by Matt Lutton

    Percent of Total not Correct

    Allison Suarez

      Hello,

      I am trying to use the quick table calculation for the percent of total but I am not getting the correct value. 

      I have a calculation that shows if a document was approved on-time (Met 14 day metric).  If this is yes, I want the count of the "YES" metric divided by the total number of documents approved in that month. 

      In the example data I have for December 2013 there are 28 documents that were approved on time.  There were 35 documents closed total in December 2013.  So I should see 28/35 = .8 or 80%.  However then I use the percent of total calculation I am getting 24.14%.

       

      What am I missing here? 

       

      Thanks in advance for any suggestions.

      Allie