At 2:49 PM -0800 1/15/01, Gylan Green wrote:
>Hi Dave -
>
>I did get your previous message - thanks for the assist. The subtotal and
>grand total fields in the report are actually pulling from a field in the
>"names" table called "raw numbers". Nothing that I've tried doing to this
>field - including changing the field definition from "count" to "total" -
>has created an actual subtotal. I've tried replacing this field with other
>likely-seeming fields, and still am not able to get an actual subtotal or
>grand total of gift amounts.
The field raw numbers is a count of Record Marker. There's no way
you're going to get amounts out of that. To avoid complications
elsewhere, you should change this back to it's original definition.
>I created this report using the layout wizard. I ran through the wizard
>again to see if I could find where I had made an error, but I'm making what
>seem like the only logical choices and continue getting the same result.
>
>I'm really stuck. If you have any ideas from here, I'd really appreciate
>them.
You're going to have to create a new summary field, defined to be a
total of the related field amount, to get what you need.. Check the
FileMaker User manual for more info on working with summary fields
and layout parts.
>
>Thanks for taking the time to respond - twice!
>
>Take care,
>Gylan Green
>
>-----Original Message-----
>From: Dave Shaw [SMTP:[EMAIL PROTECTED]]
>Sent: Monday, January 15, 2001 9:17 AM
>To: Gylan Green
>Subject: Re: [SUPPORT] Subtotals and Grand totals on sorted report
>
>>Hello -
>>
>>I am working on setting up a custom report layout where found sets of
>gifts
>>are grouped and subtotaled by accouting code. I went through the layout
>>wizard, choosing the columnar set-up option, and then the option to sort
>>and subtotal.
>>
>>My report is sorting correctly, but rather than getting arithmetic sums
>for
>>subtotals and grand total, I am getting numeric counts by group. So
>>instead of having $150,000 show up in my grand total, I'm getting 27,
>which
>>is the number of total gifts.
>>
>>Any suggestions would be greatly appreciated. Thanks much!
>
>
>Did you get my previous message (attached below). As I said then, the
>summary fields you're using need to be defined as totals of the field
>amount, not counts, which is what they are apparently doing now.
>
>
>To: Gylan Green <[EMAIL PROTECTED]>, "[EMAIL PROTECTED]"
><[EMAIL PROTECTED]>
>From: Dave Shaw <[EMAIL PROTECTED]>
>Subject: Re: [NEWBIES] Subtotal and Grand Totals in Custom Reports
>Cc:
>Bcc:
>X-Attachments:
>
>At 1:23 PM -0800 1/10/01, Gylan Green wrote:
>>I am trying to create a custom batch report I can give our accounting
>>department as a record of donations entered on a specific date.
>>
>>I need this report to show the donor name, source code and gift amount,
>and
>>to group and subtotal gifts by accounting code.
>>
>>I have been successful in creating the basic report layout, and everything
>>is showing up correctly except the subtotals and grand total of gift
>>amounts. What I am getting is counts of records instead of sums of gift
>>amounts.
>
>Two conditions need to be fulfilled for summaries to work right.
>First, the summary fields should be defined correctly, in your case
>as totals, not counts. Check the Options tab on the field definition.
>Second the records in the found set for which you are reporting need
>to be sorted correctly, in your case by accounting code, to get the
>subtotal by accounting code. It's most convenient to build the sort
>criteria into a script with a button on the report layout so you can
>recall the sort by hitting the button.
>--
>Dave Shaw Northwest Classics, Inc
>tel: 206-954-7526 fax: 206-625-1338
--
Dave Shaw Northwest Classics, Inc
tel: 206-954-7526 fax: 206-625-1338
