Results 1 to 2 of 2

Thread: Formulas and Groups

  1. #1

    Thread Starter
    Member
    Join Date
    Jun 2002
    Posts
    44

    Formulas and Groups

    I have been working on a report which tallies incoming clals and wait times for my company. Basically we are looking for a count of calls under a thirty second wait time, from 30 seconds - 1 minute wait time, 1 minute - 1 1/2 minutes etc...
    I have the formula working correctly however I cannot figure out how to reset the count after it goes into the next time segment as we are reporting on this for every 30 minutes of the day. for example 7:OO Am is working correctly reporting that there were 11 calls answered under thirty seconds, however past this it will keep incrementing in the &:30 detail line section (for this I will be suppressing detail lines and just looking at the summary totals in the group footer) I tried setting it to have the variable reset to zero if the time changes but all this managed to do was have a result of zero returned across the board. Has anyone any experience in this? Thanks

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Formulas and Groups

    If you are grouping on the half hour you can set your running sum variable
    to reset on change of group, which is probably what you want.

    HTH
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width