3 Replies Latest reply on May 3, 2017 10:12 AM by Shinichiro Murakami

    Grand Total Average - Table Calculation

    David Carr

      Hi There -

       

      In the screenshot below, I have created a "% to max calculation" field calculating the % of maximum for each individual, by week. *Individuals have been whited out*

       

       

      Here are my formulas for Max Call, as well as % to Max

       

      Max Call

       

       

      % to Max

       

       

      The problem I am running into is the grand totals. I need to the grand total to calculate the average of the above averages for each individual, but right now it is not doing that. For instance, in week 1, the grand total should be ((0% + 2.67% + 0%) / 3), week 2 ((1.76% + 5.33% +0%)/3) and so forth.


      Any ideas how to fix this?

       

       

       

      Thank you!!