Calculations in Subsummary Parts

[datalink]

I have a report that has a subsummary part. There are a couple of summary fields that are in the subsummary that are summing records that are sorted into that part.

I need to be able to write a calculation that uses those summary fields and displays the result in the subsummary part. What seems to be happening is that even though the calculation field is located in the subsummary part it is calculating on all records in the found set. So my result is across the entire found set and not constrained to the records sorting into the subsummary part.

Anyone have any suggestions?

Thanks in advance.

[comment]

Check out the GetSummary() function.

[datalink]

I did. It seems to be requiring the breakfield to be in the main table...and its in a related table. I suppose I can set up some clunky workaround to mirror the breakfield in the main table.

Seems really kuldgy to do that though.

[comment]

Alas, that is true: you need a calculation field = Related::Breakfield in the local table (unless you can use a local field as the breakfield to begin with).