### Title

Help in creating summary field in a financial budget

### Post

3-19-2009

Greetings and thanks for taking my question.

Version 9

Question: I have created a financial budget using the numbers from the old year budget and projecting a New Year budget. It also includes a field for dollar change and (%) percentage change. This all works fine. I also subtotal the various accounts by a field and I obtain subtotals calculations for these fields. The dollar change field on the subtotal summary is correct. The percentage increase or decrease for the subtotal is incorrect. I am assuming that I need to make this a summary field instead of a calculation field, but I have not been able to make this come out correctly. My last attempt of creating this summary field was using: average of, summarize information. I trust I am explaining this correctly. Thanks for your help...hk

It's hard to tell you what to do without a better understanding of your "percent decrease" calculations. I can point out that you can use summary fields in the definition of a calculation field and treat this field as you would a summary field for placing it on a layout.

Example: you can define calculation as SummaryFld1 + SummaryFld2

Sometimes this approach will give the summary calculation you need.