5 Replies Latest reply: Aug 16, 2013 5:03 PM by Celambarasan Adhimulam RSS

    Calculating a percentage



      I’m attempting to display the percentage of processing time for various jobs.  I initially created a straight table chart with the following:



      Effective Date

      Job Group



      Sum([Duration In Minutes])


      Relative is checked.


      I have about 25 job groups.  The problem is that when I select a few job groups instead of displaying all job groups my expression displays numbers that increase so that the total is 100%.  That’s not accurate.


      What I need is for the correct percentages to be displayed whether displaying all the job groups or only looking at a few.


      Any help would be greatly appreciated.