Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

078274121, info0a ip, should prodicers of software_based services be held liable or not liable for economic injuries, should producers of soft ware based services such as ATMs be held liable for economic injuries suffered when their systems fail?, nisc wwwxxx, wwwxxx0cm, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?, wwwxxx0cm, www.webdp.net, Event 9 IIS log failed to write entry

Links

XODOX
Impressum

#1: "Group By" calculation

Posted on 2008-04-18 03:59:23 by Diego B

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.

Thank you in advance,

Diego

Report this message

#2: Re: "Group By" calculation

Posted on 2008-04-19 08:29:37 by Helpful Harry

In article
<1f0eaf1a-1149-4f51-beb0-9bb2659826ee@f63g2000hsf.googlegroups.com>,
Diego B <messadua@yahoo.it> 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 report. This new
field can then be used in the GetSummary function.

For example, if you want the Sort Order for a Sub-summary report 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 hardships ;o)

Report this message