June 28, 200421 yr I am working on a solution to calculate Benefit Hour Accruals based on entries on a Timesheet. For each hour that is entered on the Timesheet, the user accrues Benefit Hours (Sick/Personal or Vacation) based on their individual Accrual Rate. The Accruals need to cap out at a certain number of hours for the year, for the week, and at an upper limit (after which they must use some before they can begin accruing again). The only way I have determined this can be done is using scripting, but I would love to do with only calculations. I keep running into trouble with circular references. Any ideas? Thanks in advance.
June 28, 200421 yr Can you attach a sample copy of the file? I'm not too familiar with payroll calculations. We can probably do what you want using GetField( ) though.
June 28, 200421 yr Here is a FileMaker Technical Article about how to do this, and a quick and dirty sample file that I made up using it as a model. http://www.filemaker.com/ti/101879.html HTH Lee Vacation_Accrual.fp5.zip
Create an account or sign in to comment