AnsweredAssumed Answered

Help with calculation. How to count number of records in field

Question asked by lenl on Sep 1, 2016
Latest reply on Sep 2, 2016 by lenl

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.

Outcomes