Filemaker Pro 8.5 Advanced Maintenance TG761Z/A Manuale Utente
Codici prodotto
TG761Z/A
160 FileMaker Functions Reference
GetSummary
Format
GetSummary(summaryField;breakField)
Parameters
summaryField -
that returns a reference to one.
breakField - field, or an expression that returns a reference to one. To calculate a
value, use the same summary field for both the summary field and the
parameters.
The GetSummary function must be set up in the same table as the break field.
Data type returned
number, date, time, timestamp
Description
Returns the value of summaryField for the current range of
by breakField. This produces
. If the database file isn’t
sorted by the break field, the result is blank.
When a summary field is also used as the break field, returns the summary field value for
the entire
When a summary field is also used as the break field, returns the summary field value for
the entire
of records (a grand summary value).
Use the GetSummary function to capture summary values when you want to:
•
•
Use summary values in a calculation
•
Display subsummary values in
Calculations using the GetSummary function are
Note
You can get similar results using a
relationship and “Aggregate functions”
on page 17. For more information, see FileMaker Pro help.
Examples
GetSummary(Total Sales;Country) returns a summary of all records pertaining to
the value in the Country field.
GetSummary(Total Sales, if(Number of Countries > 1, Country, Sales
Zone)) returns a summary of Total Sales by Country if Number of Countries is greater
Zone)) returns a summary of Total Sales by Country if Number of Countries is greater
than 1. Otherwise, it returns a summary of Total Sales by Sales Zone.
GetSummary(Total Sales;Total Sales) produces a summary of all records
(similar to using a summary field, which is a total of total sales).
If(ThisCharge > 3 * GetSummary(AvgCharge;Customer), “Verify this
charge”, “ “) displays
charge”, “ “) displays
Verify this charge
if the current charge is greater than three
times the average charge.