Jump to content
Sign in to follow this  
LemlerInv

Is it possible to add summary values?

Recommended Posts

Hello All,

I'm building a summary report. The break field has 5 values, Cash, Cashier Check, Money Order, Mastercard or Visa. The summary report breaks these values down into a total dollar amount for each. I now would like to add the summary values of Cash, Cashier Check and Money Order, then add the summary values of Mastercard and Visa.

I tried the GetSummary function, but it doesn't get me what I want, or I'm not using it correctly. Any thoughts?

Thanks in advance,

Lisa

Share this post


Link to post
Share on other sites

Here's one way: Add another calc to the file to determine the Payment Class, "Funds" or "Credit" (there may be better names.)

Payment Class (calculation, text result) =

Case( Payment Type = "Cash" or Payment Type = "Cashier Check" or Payment Type = "Money Order", "Funds",

Payment Type = "Mastercard" or Payment Type = "Visa", "Credit",

"Unspecified" )

Then add a part to the layout "Sub-Summary by Payment Class". Add your Total field to this part, and the Payment Class if needed. Then sort by Payment Class (instead or in addition to your current sort, just make sure this is above the Payment Type criteria in the sort order.)

Share this post


Link to post
Share on other sites

The GetSummary should work but you will need to use it 4 times for the first sum and 2 times for the second. A sort is required just as for the summary.

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.