Solved

Crystal Summarizing Max

Posted on 2009-07-14
5
1,113 Views
Last Modified: 2013-11-15
I have a report that I want to display the sum of field {priceinfo.tsc}; however, it also displays field {mbillcode.total} which could have many results for just the first one.  I made priceinfo.tsc into a max summary so that it would only display the result once.  I know that you can't summarize a summary so I can't come up with a solution.  If I put the same max summary in the report footer, it just shows 1 result.  Can anyone help?
0
Comment
Question by:fleets9876
  • 2
  • 2
5 Comments
 

Author Comment

by:fleets9876
ID: 24854874
Max points
0
 
LVL 5

Expert Comment

by:jgbreeden
ID: 24855420
You can use a sum on the original field, you just need to figure out what to put in the "Evaluate When" so that it only evaluates once per parent record.   if priceinfo has an ID field you could use priceinfo.ID <> previous(priceinfo.ID), or if mbilltotal has a sequence it could be mbilltotal.sequence=1.
0
 
LVL 34

Accepted Solution

by:
James0628 earned 500 total points
ID: 24856659
I assume that you have a group on the report and when you said "I made priceinfo.tsc into a max summary so that it would only display the result once", you meant that you were doing a maximum of that field for that group.

 I am also assuming that priceinfo.tsc is a numeric field.

 You can get a total using a running total.  Put {priceinfo.tsc} in the detail section, if it's not already there (you can delete it later).  Right-click that field and select Insert > "Running total".  Change the running total name if you like.  The "Type of summary" would be Sum.  Under Evaluate, select the "On change of group" option and select the appropriate group from the dropdown list.  Then the field will only be added once for each group.  If this is a grand total, under Reset, select Never.  When you click OK, a running total field will be put on the report.  Move it to the report footer if it's not already there.  That should give you your grand total.

 If you added {priceinfo.tsc} to the detail section at the start of this, you can delete it now.  I just had you put it there to make it easier to create the running total.

 James
0
 

Author Closing Comment

by:fleets9876
ID: 31603440
This worked perfectly!
0
 
LVL 34

Expert Comment

by:James0628
ID: 24865714
Glad I could help.

 James
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question