asked on

Running Total

Hello,

I am calculating a count of tickets modified by each Help Desk analyst's by using 3 formulas as below. The issue is I have to do the same thing for almost 60 users. So creating 60*3 = 180 formulas is too much work. Is there an easiest way to handle this?
Please assist.

Thank you

@Yemmy Count
 
WhilePrintingRecords;
Global NumberVar Adeyemi;
 
if {HPD_Search_Assignment_Logs.Last_Modified_By_2} in ["adeni001"] then 
if onlastrecord or {HPD_Search_Assignment_Logs.Incident_Number} <> next({HPD_Search_Assignment_Logs.Incident_Number})  then
(
  Adeyemi := Adeyemi + 1;
Adeyemi
)
 
@Yemmy Reset
 
WhilePrintingRecords;
Global NumberVar Adeyemi:= 0;
 
@Yemmy Footer
WhilePrintingRecords;
Global NumberVar Adeyemi;
Adeyemi

Open in new window

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

angel7170

ASKER

Thank You!
"You could also use a crosstab report with the rows being the user and the column being the tickets changed."

This works perfectly. What I did is grouped it by field {HPD_Search_Assignment_Logs.Last_Modified_By_2}

But I am wondering if I have complex formulas for count of "Assigned", "Escalated" by each analyst then how am I going to it.

Please help. Thank you

@Assigned Count
 
WhilePrintingRecords;
Global NumberVar TotalAssigned;
 
if ({@Assignee History} like "adeni001" or  {@Assignee History} like "NA") and 
({HPD_Search_Assignment_Logs.Submit_Date2} in {?Start Date} to {?End Date})
Then
if onlastrecord or 
 
{HPD_Search_Assignment_Logs.Incident_Number} <> next ({HPD_Search_Assignment_Logs.Incident_Number}) 
 then 
(
   TotalAssigned := TotalAssigned + 1;
 TotalAssigned
)
 
@Escalated Count
 
WhilePrintingRecords;
Global NumberVar TotalEscalated;
 
if {@Assignee History} like "adeni001" and not ({@Assignee History} like {@Assignee})
  then
if onlastrecord or 
 
{HPD_Search_Assignment_Logs.Incident_Number} <> next ({HPD_Search_Assignment_Logs.Incident_Number}) 
 then 
(
   TotalEscalated := TotalEscalated + 1;
 TotalEscalated
)

Open in new window