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.
Thanks for responding.
Each records has a change in its percentage, positive or negative, depeding on the budget increase or decrease. My individual records record the change sucessfully. It is when I group the data that the percentages to not equal the percentage change total of the records grouped.
The calculation formular for each record is:
Dollar change in budget (new budget substracted from old budget) divided by old budget. This works fine.
This does work when I group the data.
Possibly this will assist. Thanks again...hk
Should be "does not Work" when I group the data.
Here's a forum tip I recently learned: There's a forum option in a drop down menu in the upper right corner of your posted message that let's you edit your post after you post. It's saved me a number of such "daaaaaaa" moments :smileyvery-happy:
If I undstand correctly, the problem is that you don't get the sub total you need, correct? If so, look up the function "GetSummary" in the on line help function. I think it'll give you what you need. Getsummary enables you to produce calculated subtotals if you sort on the same field you specify in your "break" field (a parameter you specify in the function.)
Thus you might try: GetSummary(new budget,breakfield) -Getsummary(old budget,breakfield)) / Getsummary(old budget,breakfield)
GetSummary ( summaryField ; breakField )
Thanks for responding again. Also, thanks for you hint on the edit of messages.
I have reviewed the get summary. It is just a little more in depth than I can utilize and/or have the understanding for right now....homer
GetSummary should probably be called "GetSubtotal". The break field is the field you sort on in order to organize your report into your sub summary groups. Make sense?
Let's say you have three fields DateField, Cost and TotalCost--a summary of Cost.
If you sort your records by DateField with a subsummary part (when sorted by DateField) you would see:
DateField:3/1/09, Total Cost 70.00
dateField 3/2/09, Total Cost 30.00
Thus: GetSummary(datefield,TotalCost) will return 70.00 on the first two records and 30.00 on the last two records, but only if you've first sorted by date.
Hope that helps.
You know, don't why, but I get confused between sum(), summary, getsummary()
Like, with just a one table database, and no relationships (only one table occurrence), if you create a subsummary report layout, sort by the breakfield, and go to Preview, if the Summary field is in the sub-summary part, and the GetSummary field (based on the same summary field) is also in the Subsummary part, you get the same number for both. So what is the difference between them?
That last post is encouraging. You are starting to figure things out.
GetSummary and Summary will give you identical values if both are placed on a subsummary part that sorts by GetSummary's break field. But notice that if you don't define the subsummary part, (but do sort on the break field), GetSummary will still return the value you now see, while the Summary field might show an entirely different total. Thus, you can use GetSummary in situations where the current layout isn't compatible with the subtotal that you need in a script or calculation definition.
Sum, on the other hand, has a variety of different uses that are spelled with good examples in your on line help file.
Sum(field1, field 2, field3) is the same as field1 + field2 + field3
Sum(repeatingfield) adds up all the repetitions in the repeating field
Sum(relatedtablename::field) adds up all the values of field from all the records in RelatedTable that are related to your current record--this last option is great when you list values in a portal and want to show a total for all the records listed in the portal.