10 Replies Latest reply on Sep 2, 2016 7:21 AM by lenl

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


      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.