Average

[jalenben1]

I have 2 or more MTTR times in my CR listed as follows:

2:48
2:46
3:15

The times were already calculate in a database before I brought it over in Crystal. I dont need to calculate the time differences at all. Now that I have those times I need to get the average of the times. The filed name is Huawei_Dashboard.MTTR Restoral Time. I would like to also show the MTTR in this format days.hours.minutes.

 

[lbass]

If these are durations, you need to convert them back to minutes by using:

//{@mins}:
stringvar array x := split({table.duration},":");
val(x[1])*60 + val(x[2])

You can then insert an average on this formula set the following equal to "dur" in faq767-3543 assuming you are averaging this at some group level:

average({@mins},{table.groupfield})

-LB