I am new to FileMaker scripting. Any help is greatly appreciated.
Trying to make write a script that counts the number of records in a field called Week. I want to take that number, multiply by 5, then subtract from that number the value in a cell entitled Alex Days Off Total and have that divided into the value of a cell called Alex Yearly Total.
Basically, the Total Hours Worked / ((Number of Weeks worked x 5) minus Total Number of Days Off)
I have this: Alex Yearly Total/((Count(Week) * 5)- Alex Days Off Total)
The script seems to not be counting the number of records properly. I think Count(Week) isn't working.
Any help is appreciated,