[solved]Question about GetSummary ( summaryField ; breakField ) function

[yaya]

The attachment file is FileMaker9 file which has 2 tables inside.

The 1st is original one, the 2nd are created one by myself, they have exact same fields. (I've delete all other non-related fields from the 1st table).

1. Country TEXT (show contry names)

2. Price number (different trips in those contries)

3. Price total Summary (Caculate the total amount for all price field)

4. Subtotal Caculation use "GetSummary(summaryField;breakField)" function to caculate subtotal price for all trips in each country.

When Created Subtotal field, I use Specify Caculation "GetSummary ( Price Total; Country)"

Problem:

The original table adventure works fine, no problem.

I created exactly the same tatble adventrue222 , input some test data, Summary field doesn't show anything at all.

Please anyone can work out what the problem might be and the solution.

GetSummary_Question_Copy.zip

Edited May 21, 2008 by Guest

[comment]

One is sorted (by Country), the other is not (sorted at all). Sub-summaries work only when records are sorted by the relevant breakfield.

[yaya]

Thank you very much, I just sorted country and it's working perfect, thank you very much B)