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
CarloVasquezAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
You need to filter based on the bin or not include the bin in the query.

mlmcc
0
 
James0628Connect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.