HangoutGuy
Registered User.
- Local time
- Yesterday, 16:44
- Joined
- Aug 6, 2019
- Messages
- 28
Hi all,
I was wondering if it were possible to make a calculated field or a query that will take all of an employees certain record and sum them all into a total that will be its own column.
For instance Employee 1 is working on Project 1 and Project 2 both with a 50% dedication of service to each project. Employee 1's Total column should add to 100%.
Employee 2 works on Projects 1, 2, and 3 with a 25%, 25%, and 20% dedication of service respectively which would mean their total column would say 70.
Is this possible, and if so what is the right course of action?
I was wondering if it were possible to make a calculated field or a query that will take all of an employees certain record and sum them all into a total that will be its own column.
For instance Employee 1 is working on Project 1 and Project 2 both with a 50% dedication of service to each project. Employee 1's Total column should add to 100%.
Employee 2 works on Projects 1, 2, and 3 with a 25%, 25%, and 20% dedication of service respectively which would mean their total column would say 70.
Is this possible, and if so what is the right course of action?