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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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