• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

Insert Summary (Sum) Gives Me a Value Much Higher than the Column Total

I have a report that pulls certain SKUs from my full sales database.  The data presented in my CR view is correct.  However, when I use Insert Summary (Sum) to total the values listed in the column, I get a huge number.  My guess is that it's summing the entire database, not just the SKUs that I show on my report.  

To narrow the SKUs, I'm using a Select Expert - Group.
{ITEMS.ITEM} in ["IZT1-UP-MG", "IZT1-UP-MR"]

How can I tell CR to sum only what is shown on the report?
0
cgettel
Asked:
cgettel
2 Solutions
 
JayConverseCommented:
Put {ITEMS.ITEM} in ["IZT1-UP-MG", "IZT1-UP-MR"] into the Record Selection formula.
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
When you use the Group criteria, it only hides groups that fail to meet the criteria.  The data has still be returned from the database and is present in the report.  Summary fields sum every records, whether they're displayed or not.

So, the real question is "why are you using group selection criteria?"  Is it simply that you used Group instead of Record?  If so, Jay's advice is good - just move the criteria.  If there's a good business reason for using it in the group selection criteria, though, then instead of a summary your best bet is to use a running total field that only increments the sum based on the values you want.

~Kurt
0
 
mlmccCommented:
Summary functions use all the records that the report pulls from the database.  So even though you are suppressing them, you are still using them in the summary.

You could create a formula like
    if  {ITEMS.ITEM} in ["IZT1-UP-MG", "IZT1-UP-MR"]  then
          {NumberField}
    else
          0

You can then use a summary on that

mlmcc
0
 
cgettelAuthor Commented:
That did it!  Thank you so much.  
Jay's answer fixed the problem.
rhinok's answer helped me understand so I don't make the same mistake again.
So, I split the points.  
Sorry mimcc, I saw the other two answers first.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now