How to Perform Calc on Running Total Summary?

[Werper]

Hello,

I am writing an inventory database where I need to have a running total summary based upon several variables. I am able to do a running total summary with no problem, and I can do the variables calculation too, but how do I perform both simutaineously? The field definitons don't seem to allow both a summary and calculation at the same time.

Any info would be greatly appreciated!

Thanks,

Tom Bardenwerper

[email protected]

[LiveOak]

If I understand the question correctly, you want to take a summary field and base a calculation upon it. To do this you must use the GetSummary(field,break field) function.Say you wanted to add five to a total generated in a summary field. The calculation would look like:

ResultField =

Get Summary(TotalField,TotalField) + 5

for all the records in the file. To do the same thing in a Subsummary part based upon the field Category, the calculation would look like:

ResultField =

Get Summary(TotalField,Category) + 5

This is a silly example, but such calculations are useful in calculation percentages based upon summary numbers. -bd