3 Replies Latest reply on Mar 11, 2011 9:32 AM by philmodjunk

    YDT Total

    grocha

      Title

      YDT Total

      Post

      2nd try here folks

      So i have my timesheet setup, i went to setup new report. In report i choose all fields i use on my timesheet

      <<Name_Full>>    

                             week_date_begin    rg_hrs      ot_hrs

      Project_Code

      Project_Code

      Totals Totals Totals

      i dotn have a ytd field do i have to create it?

        • 1. Re: YDT Total
          philmodjunk

          Depends on your design. If you find records only for a given year, a simple summary field will compute the year to date total and yes, you will need to define that field and add it to your layout if you have not already defined such a field.

          • 2. Re: YDT Total
            grocha

            Stupid question does this require a script? Thats the part i cant figuire out is how to get it to give me that number.

            • 3. Re: YDT Total
              philmodjunk

              It requires that you perform a find. That can be done either manually or with a script.

              To find all records for the year 2011, you can enter find mode and enter 2011 into the date field and then perform the find. If this report is for a specific employee, you'd also enter an employee number or name in the appropriate field before performing the find.

              If you are unfamiliar with summary fields, you can look that up in FileMaker Help.