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!