summary fields

[belgiumbruno]

Hi,

I want summary + subsummary fields on a report.

Because this are totals from thousands of calculated fields, it will take hours to make them. Is there another way to make this summary + subsummary fields. Ex. First make a script that put the calculated field in a number field and then make summaries of this fields ?? Is this faster ?

thanks,

Bruno

[Fitch]

The slowness is a problem with unstored calcs. One thing you could try is to create a reporting file in which you import the calcs into plain number fields, then summarize those. If you want to get fancy you could then store the summaries into plain fields, and then let the user store the report and quickly retrieve it later.

[BuddySystems]

One thing I do that might help, is where I'm doing calculated fields that have similar definititions: use excel to build them:

For example, for the information that is the same, I put all of that in the same column, with the info that's different in the next column, etc.

COLUMN: A B C D E F G

IF(field 1 =field 2 , x ,"")

IF(field 2 =field 3 , y ,"")

Then I save the whole thing as tab separated text, open it in word, remove the tabs, and copy each line into the definition.

You can also add another column(s) for the title of the field and copy that and paste.

This can save you hours of time.