Calc Fields in Subsummary Part

[jcadysf]

I would like to put a calc field in a subsummary part so that for each subsummary section, the field would calculate the percent difference between the averages of two columns of numbers as calculated by two summary fields which I've set up to take the averages of those two columns of numbers.

So far as I can tell, FM summary fields don't allow calculations other then those that can be selected with radio buttons in the "Options for Summary Field..." dialog box.

Summary fields that perform formula operations are allowed in Appleworks 6 databases, so I'm surprised that they are not in FM.

Thanks for your help!

[PinnWal]

If you place an unstored Calculation field in the Subsummary Part, then it will summarize whatever value it is you currently wish to summarize.

Hope that helps...

[Steven H. Blackwell]

Take a look at the GetSummary fucntion. It allows a summary to be calculated (following the sort) and then the result to be used in some calculation.

Old Advance Man

[onno]

I have the same problem, and using an unstored calc field only worked for the first item in the report.

Here's my reporting problem :

I am trying to make a report layout showing the amount of money remaining for different budget items.

The budget has several elements like telephone bills or equipment. For each budget element, the amount of money available is set at the beginning of the year.

All expenses are separate records in a FM file.

For the report i have created a summary field called TotalBuy. After sorting the records on budget items, iget a report displaying the amount of money spent on the different budget items. So far it works.

What i would like to do is to show the initial amount of money set per budget item minus the total of buys related to that particular item.

Creating a regular calculated field (InitialBudget-TotalBuy) only works for the first budget item (I wouldn

[onno]

I have the same problem, and using an unstored calc field only worked for the first item in the report.

Here's my reporting problem :

I am trying to make a report layout showing the amount of money remaining for different budget items.

The budget has several elements like telephone bills or equipment. For each budget element, the amount of money available is set at the beginning of the year.

All expenses are separate records in a FM file.

For the report i have created a summary field called TotalBuy. After sorting the records on budget items, iget a report displaying the amount of money spent on the different budget items. So far it works.

What i would like to do is to show the initial amount of money set per budget item minus the total of buys related to that particular item.

Creating a regular calculated field (InitialBudget-TotalBuy) only works for the first budget item (I wouldn

[onno]

Thanks a lot, Old Advance Man

It works perfectly!! (Submitting my problem a little bit earlier to the forum...would have saved me a frustrating evening).