3 Replies Latest reply on Jan 17, 2012 12:18 PM by JessicaFiorini

    Trouble with Precentages

    JessicaFiorini

      Title

      Trouble with Precentages

      Post

      Hello,

      I am creating a task report. I have two summary fields: Count of Date Created (Total Created) and Count of Date Closed (Total Closed). I'd like to display the % of open tasks. I tried to make a calcuation field that was Total Created / Total Closed but was coming up witht the wrong amount. There are 2 closed tasks and one open task but it gives me a total % of open tasks as 66%. I'm not so great at math, but I'd assume that the correct amount would be 33%. I've tried to follow some other posts to no avail.

      Thanks in advance!