2 Replies Latest reply on Jan 27, 2015 10:31 AM by Naquiyah Cash

    Grand Total on numerous metrics - Not working on some metrics

    Naquiyah Cash

      Hi Tab Gs

       

      I have read most of the forum topics on this and blogs however most of the resolutions on grand total being incorrect and solutions are on one measure.

       

      Below I have a table with 6 measures from which all the grand totals are fine apart from 2 and not sure how to fix this. i know its got something to do with some aggregation but no clue how to solve for it.

       

      Metrics I need a resolution for on the Grand Total:-

       

      Total Hours Worked - (This is Count of Dept + Name ) * Number of hours in Dec

       

      formula - COUNTD([Dept + Name]) * SUM([Working Hours (Working hrs 2015)].[Monthly Working Hrs])

       

      This should be 1288 not 3864

       

      % of Time Tracked -  ([Time in Hours]) / [Total Hours Worked]

       

      This should be approx 2%

       

      Screen Shot 2015-01-23 at 4.23.54 PM.png

       

      If anyone can help me that would be great!

       

      Thanks

       

      Naquiyah