CREATE A REPORT WITH THE SUM OF UNIQUE VALUES

[eliasnoueira]

I am creating a work order application, the application consists of 3 tables
- work order - hours worked - employees

The first table is work orders

The second table is a form that employees can use to record the hours worked on the work order

What I am trying to create is another table that contains the sum of the hours worked by each employee in this specific service

That is, the hours worked table currently has the following structure

WORK ORDER NUMBER	DURATION	EMPLOYEE NAME
1836	03:35	A
1836	06:30	C
1836	01:13	A
1836	06:25	D
1836	02:56	B

I want to create the following table

WORK ORDER NUMBER	TOTAL HOURS	EMPLOYEE NAME
1836	04:48	A
1836	06:30	C
1836	06:25	D
1836	02:56	B

[Rafael_ANEIC-PY]

Hello there @eliasnoueira, well, there are several ways you could go around making that, my question is why would you need another table just for storing the information that is already there?

If you want to print out a report or a weekly-monthly-whathever hours report you can do that already in a google doc template using start expressions for example.

If you want to have the total hours for each user, if the "Employee name" column is made into a REF to a "Employees" table then you would have that already done for you.

And since your HOURs table doesn't include a start and end time, I'm guessing it's irrelevant, so you might as well just use a "clock in" button that allows the user to add a duration value and have it added as a new row if there were no hours clocked in before, and if there were, to just have the new hours added to the existing hours.

[eliasnoueira]

I want to create a table that shows the sum of all the hours worked by each employee in this service to show a summary of all the hours instead of showing the current table that contains all the registered hours

I don't want to create a PDF report, I want this summary to be shown inside the app, on the work order page

And yes, the hours contain start and end time, I did not put in this example app to simplify

[blaineiler]

I have a similar need. We are tracking raw materials needed for a work order, and then for each raw material, we track picks and returns. There could be more than one lot number for a given item. So we need to sum up the picks and returns -- and then subtract returns from picks to get "total usage" -- for each lot for each item. We have all of the data but haven't figured out how to get all of the calculations yet.