You should apply the formatting after the sum. Your Phone Assistance Time formula would then become
SUM([Database2].[Ready Time])+SUM([Hold Time])+SUM([After Call Work])+SUM([ACD Time])
And then create another expression to format that
IIF([Phone Assistance Time] % 60 ==60,0,[Phone Assistance Time] % 60)// seconds
+IIF(INT([Phone Assistance Time]/60) %60 == 60, 0, INT([Phone Assistance Time]/60) %60) * 100 //minutes
+INT([Phone Assistance Time]/3600) *10000 //hours
Ops Sample Dashboard_v10.2.twbx 196.7 KB
Thank you! This worked perfectly.
I have a similar question. I am trying to show the number of tickets that have been open for less than 8 hours, less than 24 hours, between 24-72 hours and then anything more than 72 hours. I have a field for time elapsed in hours but my number of records is not adding up. Any thoughts?
I have been using this formula:
IF [Time Elapsed (Hours)] <8 THEN "0 to 8"
IF [Time Elapsed (Hours)] >24 THEN "24 to 72"
I then would change this to a count field.