Get SUM in SSRS report

• sql_ques

  SSCommitted

  Points: 1546

  More actions

  January 23, 2014 at 3:34 am

  #282722

  Hi

  I have an SSRS report which gets the count of number of tickets for each type. I also need to calculate the SUM of time taken to process each ticket. For Type - Financial, No. of ticket = 3, the Total time should be (90+30+60) and not just 90. Total time is in minutes. How can I calculate the SUM?

  I tried =SUM(Fields!Estimate.Value) but its not working.

  PeroidType Total TimeNo. of tickets

  Jan-14Financial 60 1

  Jan-14Financial 90 3

  Jan-14Data 100 1

  Jan-14HR 0 2

  Jan-14HR 30 1

  Thanks for help

• pietlinden

  SSC Guru

  Points: 63494

  More actions

  January 23, 2014 at 2:32 pm

  #1682943

  Is that your intended input or output? Either way, in order to help you, please post both. I created a dummy query for the data you provided:

  SELECT 'Jan-14-2013' AS Period, 'Financial' AS Type, 60 AS TotalTime, 1 AS NumTickets

  UNION ALL

  SELECT 'Jan-14-2013' AS Expr1, 'Financial' AS Expr2, 90 AS Expr3, 3 AS Expr4

  UNION ALL

  SELECT 'Jan-14-2013' AS Expr1, 'Data' AS Expr2, 100 AS Expr3, 1 AS Expr4

  UNION ALL

  SELECT 'Jan-14-2013' AS Expr1, 'HR' AS Expr2, 0 AS Expr3, 2 AS Expr4

  UNION ALL

  SELECT 'Jan-14-2013' AS Expr1, 'HR' AS Expr2, 30 AS Expr3, 1 AS Expr4

  If you post some data like that, it's a lot easier for someone to just slap up a quick report and see what you might be doing wrong.

  Is the above your expected input or output? Please provide the other part.

  Thanks!