I have some data every now and then that needs to process percentages.
Example: Employees hours written on projects, need to be transferred into a percentage per project of the total time they submitted. So if someone submitted:
15 hours project A
30 hours project B
70 hours project C
2 hours project D
The total is 117 hours, and I want to know how much percent every project is of the total, so Project A is 12,82% project B is 25,64% and C 59,83 percent etc.
Do you gave any idea how I can calculate this the easiest way within a parabola run?
I came up with this (out of the top of my head):
- divide the report per employee
- for that employee calculate the total
- add the total to that employees list
- use pivot table to be able to calculate with the numbers (calculation is not possible with rows, only columns, right?)
- calculate the percentage per project
- use percentage to calculate which part of the total employer costs for this employee (coming from another CSV list) should go to that project
So if employer costs for that month for that employee are 3,000 Project A (12,82%) would make 384.60, Project B (25,64%) 769.20 and C (59,83%) 1,794.90 etc.
That are at least 6 steps per employee, so times 20 that is going to be a a lot of steps on the canvas.
I wonder if I am maybe thinking to complicated, and maybe there is a much faster/easier way to calculate it.
I hope some of the extremely intelligent people here can brainstorm for/with me if there is a better way.
Thank you all in advance!