I am trying to create a report that calculates "travel time" start and end. This is a custom field added to a work log.  I want to calculate the sum of this column but cannot see and option.  here is my query can anyone help? 

SELECT rctd.FIRST_NAME "Time Spent Technician",wo.WORKORDERID "Request ID",ct.CREATEDTIME "Time Spent Created Time",rctd.FIRST_NAME "Time Spent Technician",aau.FIRST_NAME "Requester",wo.COMPLETEDTIME "Completed Time",ct.TIMESPENT "Time Spent",ct.TOTAL_CHARGE "Time Spent Total_Charge",wlf.UDF_DATE1 "Travel Time Start",wlf.UDF_DATE2 "Travel Time Arrive" FROM WorkOrder wo LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID LEFT JOIN WorkLog_Fields wlf ON ct.CHARGEID=wlf.WORKLOGID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID INNER JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID WHERE  (((ct.CREATEDTIME >= 1431838800000) AND ((ct.CREATEDTIME != 0) AND (ct.CREATEDTIME IS NOT NULL))) AND ((ct.CREATEDTIME <= 1432443599000) AND (((ct.CREATEDTIME != 0) AND (ct.CREATEDTIME IS NOT NULL)) AND (ct.CREATEDTIME != -1))))  AND wo.ISPARENT='1'  ORDER BY 1 NULLS FIRST  

Your Version : 8.3 Build 8309

Latest Version : 8.3 Build 8309 [Details]

Database : postgres

ServiceDesk Plus MSP