Running Total

Posted on 2009-04-28
Last Modified: 2012-05-06

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


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;



@Yemmy Reset


Global NumberVar Adeyemi:= 0;

@Yemmy Footer


Global NumberVar Adeyemi;


Open in new window

Question by:angel7170
    LVL 100

    Accepted Solution

    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.


    Author Comment

    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
    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})
    if onlastrecord or 
    {HPD_Search_Assignment_Logs.Incident_Number} <> next ({HPD_Search_Assignment_Logs.Incident_Number}) 
       TotalAssigned := TotalAssigned + 1;
    @Escalated Count
    Global NumberVar TotalEscalated;
    if {@Assignee History} like "adeni001" and not ({@Assignee History} like {@Assignee})
    if onlastrecord or 
    {HPD_Search_Assignment_Logs.Incident_Number} <> next ({HPD_Search_Assignment_Logs.Incident_Number}) 
       TotalEscalated := TotalEscalated + 1;

    Open in new window


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now