P & L Report no longer grouping in latest version

[Products:6,4, 3, 3, 3, 2, 3, 3, 3]
@{REPORT COST DETAILS:M.GroupCode.asc::,}
>Name|Portion|Qty|Sales|Cost|Cost%|PU|Total Profit|GP%
>>$1|||||||
{REPORT COST DETAILS:C.Name.asc,C.PortionName,
C.Quantity.Sum,
[([C.AvgPrice]*[C.Quantity]).Sum],
[([C.Cost]*[C.Quantity]).Sum],
[($5/$4)];#0.00 %;-#0.00 %,
[($4-$5)/$3];#0.00 ;-#0.00 ,
[($4-$5)];0.00,
[(($4-$5)/$4)];#0.00 %;-#0.00 %:M.GroupCode="$1"}

>Totals for:|{REPORT COST DETAILS:[='$1'],C.Quantity.Sum,[([C.AvgPrice]*[C.Quantity]).Sum],[([C.Cost]*[C.Quantity]).Sum],[($4/$3)];#0.00 %;-#0.00 %,[($3-$4)/$3];#0.00 ;-#0.00 ,[($3-$4)];0.00,[(($3-$4)/$3)];#0.00 %;-#0.00 %:M.GroupCode=="$1"}
[Totals:3,3,3,3]
>Cost|Sales|Profit|GP%
>{REPORT COST DETAILS:[([C.Cost]*[C.Quantity]).Sum];$0.00,[([C.AvgPrice]*[C.Quantity]).Sum];$0.00,[($2-$1)];$0.00,[(($2-$1)/$2)];#0.00 %;-#0.00}

An idea what is causing the system to repeat sold items many times on a single report?

This is the report

Thank you very much for reporting it. It relates with using $1 parameters together with $x expression values. That will work fine on next update.

3 Likes