cgettel
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
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