3 Replies Latest reply on Aug 4, 2014 9:21 AM by KurtSnow

    Percentage of Total

    KurtSnow

      Title

      Percentage of Total

      Post


           I have created a time sheet wherein I input hours per task for each client. I need to create a report that shows the percentage of time worked for each category compared to the total time spent for that client, e.g., meetings represents 15% of the time spent on the client. The field totalTime (Sum of hours) is, to my surprise, calculating the correct hours when I place it in the sub-summary part for both the client and the category. But, sine it is just one field, there is no way to divide by itself to get a percentage. So, I created two getSummary fields for totalTime with the break fields of client and category, but I do not get any results when I divide those two fields. What do I need to do?