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

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

    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.