Help

Sum of field values across rows

Topic Labels: Base design Formulas
306 0
cancel
Showing results for 
Search instead for 
Did you mean: 
LDKottal
5 - Automation Enthusiast
5 - Automation Enthusiast

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

0 Replies 0