Calculations in Listing and Multi-Table Reports

In Listing and Multi-Table reports, calculations are specified in the Add Columns of Calculations section of the report form. Perform the following calculations:

• Add the values of two fields, a single field and a Date/Time keyword, such as now or startof_thisweek, or two Date/Time keywords.

• Subtract the value of one field from another, a single field and a Date/Time keyword, or two Date/Time keywords.

• Divide the value of one field by the value of another, a single field and a Date/Time keyword, or two Date/Time keywords.

• Multiply the values of two fields, a single field and a Date/Time keyword, or two Date/Time keywords.

To determine how long particular items have been active in the system, specify the following parameters in the Calculated Fields to Display section:

Time Open = Close Date/Time - Submit Date/Time

When you run the report, the time representing how long items have been active appears in the Time Open column d hh:mm:ss format. This column is empty for items that have not been closed.

To determine how long items have been in the current state, specify the following parameters in the Calculated Fields to Display section:

Time in Current State = Now - Last State Change Date

When you run the report, the time representing how long items have been in the current state appears in the Time Open column d hh:mm:ss format.