Our students are required to work a set number of hours a week, which is accumulative over time each week. For example, if someone works 25 hours and is supposed to work 20, then they accumulate 5 hours flex time. And, if that same person works 22 hours the second week, they now have 7 hours flex time towards vacation.
I was able to do this in the Microsoft access database: =Sum([Subtotal])-[GlobalTimeWorked] and sorted the report by start time and placed this field in that section. However, I don't know how to replicate it in FileMaker (version 12).
I have the report sorted correctly so it parses out each week. I have the calculation to total the amount of time worked that week. But, I can't get it to calculate accumulate time worked over multiple weeks.