Duplicate Records when Grouping

I am Grouping the report by Item and I want the total for that month in sales.
Unfortunately that item is found in multiple bins for that same order so it would add multiple times the same item for that order :/

I have tried putting onfirstrecord but get an error message since this is a field that is getting summarized. Here is the that is generating the summary for that item:

if  {SYSOENT.ORDER_DATE}>= {@FromDate3} and  {SYSOENT.ORDER_DATE} <={@ToDate3} then
    {LINEITEM.QTY_SHIPPED}
    else
0
Carlo VasquezAsked:
Who is Participating?
 
mlmccCommented:
You need to filter based on the bin or not include the bin in the query.

mlmcc
0
 
James0628Commented:
FWIW, OnFirstRecord probably wouldn't help you anyway.  It's only true for the very first record in the report.

 If you can't eliminate the extra bins, as mlmcc suggested, then a regular summary may not work.  You may be able to use variables.  The specifics would depend on exactly how your data and report are structured.

 James
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.

All Courses

From novice to tech pro — start learning today.