Combining Subtotals on Columnar Report

[gaby78]

Here is the scenario: I have 2 fields: Amount field and Code field, each record is coded A, B, C, D, E, etc…. I created a columnar report with subsummary part that shows subtotals for each code. Now what I am trying to do is show on the report a combination of the above subtotals, like: SubtotalC+SubtotaD, or SubtotalA+SubtotalD-SubtotalE. I just can’t figure out how to grab the subtotals individually and combine them.

Help will be very appreciated.

[Ocean West]

you will need to create a few fields

GetSummary( SubtotalC ; Code ) + GetSummary( SubtotalA ; Code )

GetSummary( SubtotalD ; Code ) - GetSummary( SubtotalE ; Code )

[gaby78]

Thanks for replying

How do you get SubtotalA, SubtotalB...? these subtotals are produced by the summary field and are not real fields that I can grab. In the my subsummary part I have sAmount (summary field) that produce these subtotals. I have tried with Getsummary() but could not figure out how to grab the subtotals that appear in the subsummary part.

Is there a way to tell FM to grab the subtotal of code A , subtotal of code B, etc... and add or multiply them ?

[Ocean West]

perhaps this?

summary.fp7.zip