My goal is to calculate the percent of hours per week spent on a type of task. I have managed to calculate the sum of hours spent on each type of task for all entries regardless of the week number, but I can't figure out how to calculate the sum per week.
In the table where I calculate the sum of hours, I have three fields: Task, Time (from my Time Track Entries table), and Sum. The Time Track Entries table contains the week number for each timed entry.
Any suggestions for how to calculate the sum per week?
Thanks,
Lene
