1 Reply Latest reply on Jan 22, 2014 6:27 AM by philmodjunk

    Summary of hours by invoice

    IreneVafides_1

      Title

      Summary of hours by invoice

      Post

           I have table that has workers hours (records are by date, often with multiple entries for multiple workers for one date) and a table that has contains for invoices.  I need to be able to summarize the hours are that worked for each invoice as well as the total hours worked on each project.  I am having a hard time with the "in-between" totals.  Any help or guidance would be appreciated. 

        • 1. Re: Summary of hours by invoice
          philmodjunk

               often with multiple entries for multiple workers for one date

               If each "entry" is a different record in WorkerHours and if you have this relationship:

               Invoices----<WorkerHours

               Then you can either define a calculation field in invoices: Sum ( WorkerHours::HoursWorked ) or you can refer to a summary field defined in WorkerHours that computes the total of HoursWorked from the invoices layout to get the same total.