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:

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.

Note: For any calculation you create that begins with a Date/Time keyword (like now or startof_thisweek), you must ensure that the keyword is the first token in the expression. For example, the following expression:

Submit Date = (now Minus 30)

Should be specified as (without the parentheses):

Submit Date = now Minus 30

Related Topics

Two-Operand Calculations

Calculations

Single-Field Functions