Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Summary field in Trailing Grand Summary problem


This topic is 5623 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I have a fairly straightforward table (i.e., records appear as a table in View as Table) that sums up numbers in fields using summary fields. The summary fields are placed in the Trailing Grand Summary. In View as List the summary fields display just the numbers that are the sums of values in the displayed records. Unfortunately, in View as Table each summary field is preceded by the word "Total:". Because each column of numbers is very narrow, the printout of the table shows only the words "Total" (or a fraction of it) instead of the actual numbers. I am fully aware that I can resize the width of each column and make the full "Total: XX.X" appear, but this ruins the entire printout. I also need to use a Trailing summary instead of the Footer because footers do not slide up when printing.

I understand the reason why FIleMaker Inc. decided to add the word indicating what kind of a summary field it is (total, average etc.), but please, please let the user decide whether to display it or not.

Does anyone know if it is possible to display just numbers (without the "helpful" explanation of what these numbers mean) in the Trailing Grand Summary in the View as Table?

Posted

A summary field does NOT add the word "Total:" to the result on its own. Did you make this file yourself? My guess is that if you enter Layout mode and check the number format of the field, you'll find the string "Total:" in there - probably as the currency symbol.

Posted

Believe me, it does (albeit only in a Trailing Grand Summary viewed in the View as List). This horrible "feature" is even mentioned in the FM 10 help:

"When you view summary data in Table View:

[...]

- FileMaker Pro automatically adds field labels (such as Total) to subsummary parts to identify the data displayed."

Posted

Your profile indicates version 7, and your original post didn't mention version 10. Yes, in version 10 a summary field placed in a summary part will be labeled when the layout is viewed as Table. I don't see that you can do anything about it, other then design your own layout (as List).

This topic is 5623 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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