10 Replies Latest reply on May 17, 2017 11:18 AM by Noel Castillo

    Getting incorrect Grand Total for Calculated field

    Pankaj Rajput

      Hi All,

       

      I am facing issue while calculating grand total for calculated field (using Table Calculation). Like in below given example, i am not getting correct grand total for column named 'Total available Hours'.

       

       

      Here, I am using COUNTD in Calculation. And, I believe, this is because of common tasks b/w Name A,B & C

       

      Is there any way of tweaking this in order to get correct summation for calculated field. So that, I can see some actual sum of Total available hours (1983+1275+708 = 3966)

      Whereas, grand total is showing average for Average Handling Time as 11.91 which is correct based on our calculation.

       

      Looking forward to get response soon

       

      Many Thanks!!!

       

      Pankaj