Forum Discussion
MarkShnier__You
4 years agoQrew Legend
I suggest that you use a Summary report type (not a regular table report type). Group by employee name and using column groups by date , where it groups by week.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- TaraStroup4 years agoQrew MemberHello Mark,
Thank you for this. Is it possible to create formulas that report on the summarized data from a summary table?
Referring to the example above, The total hours for the summary report its great now I need to derive reg vs ot hours.
Regular hours would be whichever is less, total hours or 40
OT would =Total -Regular hours
Is this possible? and how?
Thanks,
Tara
------------------------------
Tara Stroup
------------------------------- BlakeHarrison4 years agoQrew CaptainThe route you take on that will depend on what you want to do with that information later. If you simply need to see it in the report and don't need to be able to do anything else with it, you can create a Report Formula in the settings of the report itself. However, if you think you may EVER need to do something other than look at the data, you'll need some additional structure to properly report / manipulate your data.
In your example, you are calculating Hours Worked for each Employee for a given Week. Generally, I would suggest having an Employees table, a Weeks table, a Timesheets table, and an Employee Weeks table. Employee's time will be reported on the Timesheet record (assuming each Timesheet would represent a single day for that employee). Each Timesheet would be a child to an Employee record, a Week record, and an Employee Week record. The Employee Week record could then have a summary field for the Hours Worked and a formula to calculate the OT hours for that week.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------