Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    47

    Unanswered: Need Help with a report...

    Hi there,

    I have an invoice(report), it has the following fields:

    Fee Earner, Date, Code, Activity, Minutes, Items, Cost, Disbursments, All


    It currently works out a total(All) for each record and a grand-total.


    I need to calculate a total in minutes for an Activity.

    For example, I have an activity(Telephone Calls) and i have minutes(total minutes). A total is worked based upon the cost per minute.

    I need to caculate, for example, the total number of minutes for an activity (telephone calls).

    Can someone please advise me what to do?

    Sorry if it sounds confusing, if you need any clarity please ask.

    Thanks in advance,

    Rehan

  2. #2
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    119
    You can do this with a group footer.
    So, switch on grouping for the Activity field and group footer. Then add a sum of the minutes in to the group footer.
    Regards
    JD

    Software-Matters

Posting Permissions

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