Jump to content
Sign in to follow this  
RCamejo

Summary function/Grand Summary

Recommended Posts

I have several reports that calculate the number of hours each employee works. (hrswrked)is the field, which is a calculation of ending time minus starting time.

I want to show a total number of hours for all the employees. I thought this was rather simple, I created a field (tothrswrked) that summarized the summary field hrswrked. When I run the report with the field tothrswrked in the grand summary, all I get is a ? mark in the field. I tried expanding the size of the field as I have discovered that filemaker will do this if the number exceeds the field size. However, I have expanded the field size to cover 6 inches across a page, and I still get the ? in the field. Any help would be appreciated.

Share this post


Link to post
Share on other sites

You say: "I created a field (tothrswrked) that summarized the summary field hrswrked"

If you are truly summarizing the summary field, that might be causing your problem. In the grand summary part of your layout, you need to place a summary field defined as a Total of the field that calculates hours.

If that does not work, go ahead and post your exact field definitions, including storage options.

Tom

tom@tgparker.com

Share this post


Link to post
Share on other sites

Try rounding your numbers. It is indicating one of two things: either the field is too small to display the number or you are aborting the summary before it is complete.

Share this post


Link to post
Share on other sites

I knew I forgot to include something on my posting.....If I run a small number of records, the summary field will give me the result. When I run a large number or records, for example 65 different people for a one year period, all I get is the ? mark in the field. I have expanded the field to contain up to 20 characters, and I still get the ? mark.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.