by christi » Sat, 17 Nov 2001 08:09:41
I am having a problem with the speed of a summary field calculation.
This field tallies a total of tuition $ paid for courses. The problem
is that our computers are not brand new and not that fast. They get
hung up on this field each time we enter a new record. We spend about
10 seconds waiting for the field to tabulate. Unfortunately, this
total is useful to us. Any suggestions on a better way to set-up the
calculation?
Thanks.
by John Weinshe » Sat, 17 Nov 2001 09:08:20
Some speed may be gained by placing the entire set of arguments within the
last calculation. In other words, if you are using a calc:
Field A= FieldB+3
and then a calc:
Field C= Field A*12
and Field C is the field summed, define Field C as:
(FieldB +3)*12
Finally, don't place the summary fields on a layout unless they are
necessary (they only calculate when displayed). If you need the field, but
only need it occasionally, create a layout for it, and go to that layout
when you need it.
--
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Solutions Alliance
Quote:> Hi,
> I am having a problem with the speed of a summary field calculation.
> This field tallies a total of tuition $ paid for courses. The problem
> is that our computers are not brand new and not that fast. They get
> hung up on this field each time we enter a new record. We spend about
> 10 seconds waiting for the field to tabulate. Unfortunately, this
> total is useful to us. Any suggestions on a better way to set-up the
> calculation?
> Thanks.
by Paul Brunea » Sat, 17 Nov 2001 11:50:46
PB
> Hi,
> I am having a problem with the speed of a summary field calculation.
> This field tallies a total of tuition $ paid for courses. The problem
> is that our computers are not brand new and not that fast. They get
> hung up on this field each time we enter a new record. We spend about
> 10 seconds waiting for the field to tabulate. Unfortunately, this
> total is useful to us. Any suggestions on a better way to set-up the
> calculation?
> Thanks.
1. How to make calculations based on several summary fields included in a sub-summary part
Hi all,
I have sent this mail before, but did not get a solution to my
problem, maybe because the information supplied was not enough. I will
rephrase what I stated.
FMP 5.5 WIN, FMP 5.5 server
I have created the following report (this is just a simplified example
for this message):
field1
field2
field3
summary_field1 (total of field1 when sorted by field3)
summary_field2 (total of field1 when sorted by field3)
grand_total1 (total of field1)
grand_total2 (total of field2)
So it looks in Preview as this:
Body
category1 of field3
field1
field2
Subsummary when sorted by field3:
summary_field1 (total of field1 when sorted by field3)
summary_field2 (total of field1 when sorted by field3)
Body
category2 of field3
field1
field2
Subsummary when sorted by field3:
summary_field1 (total of field1 when sorted by field3)
summary_field2 (total of field1 when sorted by field3)
etc...
The report works OK and give me a listing sorted by field, with the
summary fields correctly showing subtotals for each field3_category
(there are several categories). Please note that field3 is not the
only field that sorts the report. It is just the first field to sort,
but there are several other fields that sub-order this report.
I have taken a look at the GetSummary function, but it does seem to
work in my situation.
I need to get:
summary_field1/summary_field2
for every category of field3, not just one result for the whole
report. In other words, I should get in the
subsummary part one result for every category. I have tried creating
the following GetSummary field:
Getsummary (summary_filed1; field3)
and I have place this field in the sub-summary when sorted by field3
part of the report. Nevertheless, I get a blank result. In FileMaker
help it is stated that a blank result indicates that the database is
not being sorted by the correct filed. The fact is, it is being sorted
by that field (lathough, like I said, field3 is not the only field
that sort this report, is it just the first sort order), and I am
getting the correct result for the summary
fields and the grand-total field.
I am not sure GetSummary is the correct way to do this. There should
be a way to make the calculation when the report is sorted (at the
same time) by several fields.
Thanks for your help,
Martin
2. Error 429 - cant create ActiveX object
3. fm p 5.0 to fm 4.1 for windows
4. standard schemas for addresses, others?
5. FM Pro Server, calculations/summaries
7. Calculations on summary fields
8. Problem of SQL in version 7
9. <beginner> Text field calculations/summaries
10. HELP - Summary Calculation of portal field
11. calculations with summary fields
12. newbie question - summary field calculations