Good Day,

I am using Crystal Reports 9 with a DB2 database.

I have a report that tracks the resolution time of incidents in our incident management system.

There are two tables, one called probsummary and the other called clocks

The probsummary table contains all the information about each incident. It contains the incident number, the open time, the closed time, etc. When an incident is opened, a clock starts that tracks the time the incident is being worked on.

An incident that is a severity 1 or severity 2 uses the clock called "resolvetime." An incident that is a severity 3 or severity 4 uses the clock called "workingtime"

The clocks table contains the length of time the "resolvetime" or "workingtime" has been running. It stores the length of time in a field called {clocksm1.total.alias}

A series of formulas are then used to parse the number of total seconds that each incident was being worked on. This field is called TotalAliasSecondsDuration.

The report is grouped on the Closed Time of the incident (by Month).

In the details of the report, the incident #, closed date, and the TotalAliasSecondsDuration is displayed (in seconds).

In the group footer of the report, I have the Sum of @TotalAliasSecondsDuration and the Avg of @TotalAliasSecondsDuration

I want to have a chart at the bottom of the report that displays the Avg @TotalAliasSecondsDuration in Hours (and not seconds) and the month.

How can I chart this? Currently, it will only allow me to chart the field in seconds. I have written a formula to convert the seconds to hours, but I am unable to choose that formula in the Chart Expert.  I only have the option to display either the Sum of @@TotalAliasSecondsDuration or the Avg of @@TotalAliasSecondsDuration. I can't use my conversion formula.