Using a Grand Total in a Calculation HELP!

[laudmusic]

I'm having the hardest time getting this to work. Could be due to the lack of sleep this week, but anyway...

I'm trying to use a grand total summary result in a calculation.

I have a report with a few subsummaries and a trailing grand summary. Everything is working great up to that point.

I have an earnings summary that is a running total and restarts when sorted by income type. This is both in the sub and trailing grand summaries. Both instances work as advertised.

What I now need to do is take the grand total earning summary field and use the result in a basic calculation.

Here's what I need to do, I'm using () to illustrate where the field is on the layout:

(Grand Total) Earning Summary + Amount Adjustments Recoup Advance = Amount to be Paid

So the Earning Summary is a SUMMARY field

The Amount Adjustments Recoup Advance is a GLOBAL field which gets pulled in when a specific client is selected for a report. Can be a positive # but in most cases it's a negative, showing and unrecouped advance.

My result, Amount to be Paid, is the difference of the above. This is a global calc field performing the calculation.

In DataViewer, this works perfectly. I always use dataviewer to check calc's before I finalize.

When I add to the layout, it calcs all of my earning even the records that are omitted, so I get an overall total of the table, not current records in my report.

I've tried to use the GetSummary function hoping that would solve my problem but it seems like it doesn't work in Grand Totals.

I would appreciate some light bulbs and a hit in the head to make this work.

Thanks,

Michael :

[comment]

it calcs all of my earning even the records that are omitted, so I get an overall total of the table, not current records in my report.

I don't think that's possible (unless there's something missing from your description). However, since you restart the summary, you cannot use it directly in a trailing grand summary part (it will return only the value of the last summarized part). You need to use the GetSummary() function to get the grand total:

GetSummary ( Earning Summary ; Earning Summary ) + Amount Adjustments Recoup Advance

[laudmusic]

Well I even tried a summary that was just a total not limited and still the same issue.

Hmmm.....

[comment]

I'm sorry, I do not follow. Have you tried what I suggested, and if so - what results are you getting?

[laudmusic]

Sorry for taking so long to respond. Unfortunately, it did not work.

I did come up with a solution though.

I created another Summary field that totaled all the amounts and then was able to use that straight in a calculation, without the use of getsummary.

Just have to make sure the window gets refreshed.

Now I can generate a royalty statement and get another report generated in another table using the summary calc'd results.

Whew....

[LaRetta]

Unfortunately, it did not work.

Well now ... if you told Comment exactly WHAT didn't work, as he asked, he could help you through making it work the way you want! Telling him it doesn't work is worthless. C'mon now ... try his suggestion, stepping through it and then tell him what happens! :smile2:

[laudmusic]

I did tell him. If you read the his solution, it was a simple calculation. Nothing that I felt detailed explanation, because there is none to give.

I'm not sure if your post was supposed to be a blast/sarcastic, but it came across that way. If that wasn't your intention, please reread before you post.

[comment]

I did tell him.

I don't think you did. All you said was "Unfortunately, it did not work." There's not much one can reply to that, except "it does work for me" - which doesn't seem to lead anywhere.

I have read LaRetta's post very carefully, and I still cannot find even a trace of sarcasm in it - not to mention a blast.