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,

Thank you.

I figured it out:

Alex Yearly Total/((Get(TotalRecordCount) * 5) - Alex Days Off Total)