I'm trying to use Cross-Tab to display Incidents that are closed in the
first hour after the Helpdesk person takes it. I have my formula that
pulls the tickets to be counted.
[EMAIL PROTECTED] three months}
AND
{HPD_HelpDesk.Assigned_To_Group_}= 'Service_Desk_NAM'
AND {HPD_HelpDesk.Status} = ['Resolved', 'Closed']
AND
({HPD_HelpDesk.Status_History_Resolved_TIME}-{HPD_HelpDesk.Status_History_New_TIME})<=
.04
Which works if the formula is in the record selection. If I move the
formula to a field on the Cross-Tab I get all tickets not just the ones
I'm looking for. There is a button on the Cross-Tab to add a formula but
if seems that Cross-Tab do not use formulas. Is there a box I need to
check off to have the formula run in the Cross-Tab?
The bottom line I'm lookingg for is the percent closed in the first hour
over the total number of ticket for given month.
I tried creating a sub report with a Cross-Tab showing all tickets but
could not find a way to percent the two fields (One from the first
Cross-Tab the second from the sub report Cross-Tab.
John Atherly
American Power Conversion
[EMAIL PROTECTED]
401-789-5735 Ext. 2120
1-800-788-2208 Ext. 2120
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
