Help Please. I am trying to create what I thought would be an easy database on Knack. I have to track overtime hours that personnel work on the fire department. The formula is as simple as this:
Beginning balance + how many hours worked = balance
balance + how many hours worked = New balance
and this just keeps repeating.
The problem seems to be that you can't carry a balance from one record to the next. I am aware of the SUM function in Pages but that does not help my scenario. The SUM function does give me a balance, but it wont show everyones balance in one view. It will only show me the balance for one person, then you have to select another individual to see that persons balance. I would like the view to show all the personnel at the same time with their balance next to their name. Is there no way to accomplish this with Knack. Example:
Joe Smith - 30 hrs
John Doe - 30. 8 hrs
Bill Someone - 45 hrs
Thanks for any help!!