MarkShnier__You
3 years agoQrew Legend
Re: Combine Summary Reports
You will need to have a table of Weeks where the key field is the date that represents the Sunday of the week. Use Excel to load up all the Sundays for say the next 10 years. Set the Key field to be the date field.
Then make a relationship where One Sunday has many Employee Leaves. Let it create a field for Related Week, but then edit that field to make it a formula field
FirstDateOfWeek([my date field])
Then make summary fields on the Relationship to summarize up to Weeks the various fields you need to sum from Employe Leaves.
Repeat the process from the other table, Active Directory. Then you will be able to do your calculations on the weeks table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Then make a relationship where One Sunday has many Employee Leaves. Let it create a field for Related Week, but then edit that field to make it a formula field
FirstDateOfWeek([my date field])
Then make summary fields on the Relationship to summarize up to Weeks the various fields you need to sum from Employe Leaves.
Repeat the process from the other table, Active Directory. Then you will be able to do your calculations on the weeks table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------