Solved

Calculating Subsummaries with Functions

Posted on 2004-04-29
2
1,212 Views
Last Modified: 2010-10-05
Hi, I have a database of patient surveys, which I created in Filemaker Pro 6 and upgraded to Filemaker Pro 7.

When I viewed the new version of the database, I came across a problem apparently caused during the upgrade.  In my Report, some fields are based on the results of calculations from other fields.

For example (Responses are ranked 1 to 5--1 being bad, and 5 being good):

Admission:                Avg. Response
Staff Courtesy            3.0
Delays                       2.0
Total                         2.5

In a Grand Summary Report, the above example works fine in both FM 6 and 7.

In the above example, Total = Average (Staff Courtesy, Delays)

However, I have problems if I use sub-summaries when evaluating Total.

In FM 6, the subsummaries work without problem when calculating Total; in FM 7, however, I get the average for ALL records in the database (i.e. the subsummary is not working).

The formula I am using is:

FM6:
Total = Average(GetSummary(Staff Courtesy, Survey Date), GetSummary(Delays, Survey Date))

FM 7:
Total = Average(GetSummary(Staff Courtesy; Survey Date); GetSummary(Delays; Survey Date))

In each case, the records are sorted according to Survey Date.  


I should also add:  

Subsummaries NOT involving functions DO work in my FM 7 database.

For example, the following formula would work in my subsummary report:
Number of Patients = GetSummary(Patients Group A, Survey Date) + GetSummary(Patients Group B, Survey Date)

My problem seems to happen only when I use functions (such as Average) with parameters requesting a SubSummary.

Is it at ALL possible for me to calculate an Average using subsummaries in FM 7?  Any thoughts or guidance would be MOST appreciated!
0
Comment
Question by:tonyt1234567
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 2

Accepted Solution

by:
KungFoolio earned 500 total points
ID: 10980356
Tony,

You can't use calculations in the GetSummary function: Getsummary(SummaryField,BreakField). SummaryField is tytpe Summary.

1) Peform the average as a calculation of the fields desired. Average1 = Average(Field1,Field2,...)
2) Then define a summary (SumAverage1) field that takes the average (across all records) of Average1. Use this field to show averages for your found set.
3) To break this into subsummaries, use Getsummary(SumAverage1,SurveyDate)

Cheers.

0
 

Author Comment

by:tonyt1234567
ID: 10981930
KF, that did it!!  Thanks VERY much for your guidance.

One other question--I'm not sure why having a calculation within a subsummary worked in FM 6, but not FM 7.  Is this a difference between the programs, or was I just lucky in FM 6 (or both?)

Tony
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

687 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question