Re: "Group By" calculation

In article
<1f0eaf1a-1149-4f51-beb0-9bb2659826ee@[EMAIL PROTECTED]
>,
Diego B <messadua@[EMAIL PROTECTED]
> wrote:

> Hi all,
> 
> I would like to group a field basing on another (categorical) field,
> and I know that using subsummary parts is very easy.
> But, is that possible to group the field C by field B, already grouped
> by field A using a calculation ?
> I tried GetSummary, but I think I am wrong in something, I was not
> able to get it work.

Unless something has changed in newer versions of FileMaker, the
GetSummary can only "sort" records by a single field, so a multiple
breakdown as you want cannot be done that easily.

What you can do is create a new Calculation field (or normal field with
Auto-enter by Calculation option) that combines the three fields in the
same order as you would sort them for the Sub-summary re****t. This new
field can then be used in the GetSummary function.

For example, if you want the Sort Order for a Sub-summary re****t to be:

     Field_A
     Field_B
     Field_C

then you can create a new Calculation field as:

    MySortField    Calculation, Text Result
                   = Field_A & " " & Field_B & " " & Field_C

This gives you a way of grouping records that are within the same
Field_C by Field_B by Field_A sub-group.

Then the Calculation field using the GetSummary function will be:

    MySummary      Calculation, Number Result
                   = GetSummary(SummaryField; MySortField)

You may have a problem if the data in Field_A or Field_A and Field_B is
"too long" since FileMaker won't see Field_C (or perhaps not all of
Field_C) and therefore think two slightly different data are the same.
For example, 

     This is a very long sentence with many many characters 1

may look the same to FileMaker as

     This is a very long sentence with many many characters 2

if the "1" and "2" are past its number of characters limit.

I can't remember what the limit is, but it should not be a problem
unless the data in those first two fields is VERY long and very similar
between records.


Helpful Harry                   
Hopefully helping harassed humans happily handle handiwork hard****ps  ;o)