Jump to content

Combining Subtotals on Columnar Report


This topic is 6169 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

you will need to create a few fields

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

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

Link to comment
Share on other sites

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 ?

Link to comment
Share on other sites

This topic is 6169 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.