The default Time Spent format displayed on reports is HH:MM:SS. I would like to show it in Hours with one or two decimal places. Every time I try and use the ROUND function as suggested in the Help Card area on the field MM2COMPLETEREQUEST I get the error message "Error while fetching ajax response : Unknown runtime error". If I try the calculation without the ROUND function, i.e. ((MM2COMPLETEREQUEST/1000)/3600) it works, but does not give me quite the output I am looking for. I would like to keep this report within SDP and not resort to going directly to the MSSQL database as the formatting in SDP makes things easy without having to go to Excel.

 

Also, the report I am editing is a Matrix report, however, when you go to Query Editor and run it, it seems to change it to a Tabular Report. When I make changes to the query, how can I keep this a Matrix report?