Report Totals - Please help

[jackson via AccessMonster.com]

HI,

I've looked through threads and am unsure how to tackle this problem...

I have a report that has a list of portfolio holdings. There are 3 asset
classes of which there can be many holdings on each. Each asset class has a
target weight which I've passed into the query my report is based on - the
portfolio holdings report - thus for each record, the asset target weight
comes up but there's only 3 unique records.

In my report, I need an asset class subtotal weight which I can get by either
First, Last, Avg, etc as the asset class is how the records are grouped. Now,
I need to total these three calculated fields but I don't know how. I keep
reading you cannot sum a calculated control. If not, how would I add these
three numbers up? Seems I'd have to group in the build statement by asset
class and do the sum of that...sorry a bit lost with it, any help would be
appreciated.

Cheers.

 

[Dennis]

You can't Sum a calculated control but you can Sum a calculation
e.g CalcControl = A * B + C / D
You can then Sum this calculation by putting a control on your report with
this
=Sum(A * B + C / D)
Make sure these controls go into the correct sections of your report based