Jump to content
Sign in to follow this  
gaby78

Combining Subtotals on Columnar Report

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.

Share this post


Link to post
Share on other sites

you will need to create a few fields

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

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

Share this post


Link to post
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 ?

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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