Hi I m facing issue to add the totals and Sub-totals. Scenario: I have a Column in Report as "AHT". Based on AHT we are calculating Utilization. The Column AHT is in Time format and we used a Macro code to show the value in "hh:mm:ss" format. Utilization calculation is (AHT*86400)/60)*(ticket_Handled) Since AHT is a reportitems and is in time format I have used the condition = "((((cdate(ReportItems!txtAHT.Value)).ToOADate())*86400)/60)" This Condition is working fine at row level, But the problem is when coming to Sub-Totals and Grand Totals ,the condition is failing. How to sum this condition, I have tried "(sum(((cdate(ReportItems!txtAHT.Value)).ToOADate())*86400)/60)" "(sum((((cdate(ReportItems!txtAHT.Value)).ToOADate())*86400)/60))" not working. Please advice.

Hi, Please provide some details of what makes your 'SubTotal'. Are you using any groups in your report?MSBI Developer

Hi I m not using any groups here , this is a Matrix report.

Hi APradeep, Thanks for your question. Base on your description, I understand that you want to get a total value by SUM() aggregate function in the matrix on the report body. Actually, the reason of condition failing is not Time format, the issue is that aggregate functions can be used only on report items contained in page headers and footers. In this case, I suggest you sum the expression of AHT textbox’s value directly, please type this expression in your total expression dialogbox: =Sum((AHT)*86400/60), remember to replace the AHT with the expression of your AHT textbox’s value. If you have any question, please feel free to let me know. Thanks, Sharp Wang