(I'm using Filemaker Pro 2.1)

I have two summary fields... "Total Amount of Checks" and "Total Out of Pocket Expenses". (These are not repeating fields, they are one record per entry)

I can't seem to make a "Grand Total" calculation that adds these two up. How do I do it? Thanks!

quote:

---

Originally posted by Barbara Rainey:

(I'm using Filemaker Pro 2.1)

I have two summary fields... "Total Amount of Checks" and "Total Out of Pocket Expenses". (These are not repeating fields, they are one record per entry)

I can't seem to make a "Grand Total" calculation that adds these two up. How do I do it? Thanks!

---

Summary Fields are not stored in the database, they are only calculated when shown on the screen or printed in a report.

If you want to use them in a calculation use the "GetSummary (SummaryField, SortField)" function to get the results of the summary and perform calculations on it.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

FileMaker Pro 2.1 is *not* Y2K compliant. Stop development with it now and change over to a later version.

The GetSummary function will work, but only if the file is properly sorted. What I would do is place the summary fields on your layout, but make them so small as to be invisible; or make the text color white; or format them not to be printed. This way, the summaries will always be evaluated dynamically.