• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

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

0
angel7170
Asked:
angel7170
1 Solution
 
mlmccCommented:
One way would be to group by the user name and use summary functioins in the group footer.

You could also use your basic formulas with the reset in the group header and dislay in the group footer.

Using groups you don't have to have variables for each user.

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

mlmcc
0
 
angel7170Author Commented:
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

0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now