# P & L Report no longer grouping in latest version

**URL:** <https://forum.sambapos.com/t/p-l-report-no-longer-grouping-in-latest-version/18995>\
**Category:** V5 Question\
**Created:** [December 19, 2018, 8:06am UTC](https://forum.sambapos.com/t/p-l-report-no-longer-grouping-in-latest-version/18995 "2018-12-19T08:06:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Castech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/castech/32/38503_2.png) [@Castech](https://forum.sambapos.com/u/Castech)\
**Post date:** [December 19, 2018, 8:06am UTC](https://forum.sambapos.com/t/p-l-report-no-longer-grouping-in-latest-version/18995/1 "2018-12-19T08:06:33Z")

</div>

```
[Products:6,4, 3, 3, 3, 2, 3, 3, 3]
@{REPORT COST DETAILS:M.GroupCode.asc::,}
&gt;Name|Portion|Qty|Sales|Cost|Cost%|PU|Total Profit|GP%
&gt;&gt;$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=&quot;$1&quot;}

&gt;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==&quot;$1&quot;}
[Totals:3,3,3,3]
&gt;Cost|Sales|Profit|GP%
&gt;{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?

---

<div class="post-metadata">

**Author:** ![Castech](https://forum.sambapos.com/user_avatar/forum.sambapos.com/castech/32/38503_2.png) [@Castech](https://forum.sambapos.com/u/Castech)\
**Post date:** [December 19, 2018, 8:07am UTC](https://forum.sambapos.com/t/p-l-report-no-longer-grouping-in-latest-version/18995/2 "2018-12-19T08:07:47Z")

</div>

This is the report

 ![Annotation%202018-12-19%20100511](https://forum.sambapos.com/uploads/default/original/3X/b/2/b2607f047aba7456a815dd20c74475764523511d.jpeg)

---

<div class="post-metadata">

**Author:** ![emre](https://forum.sambapos.com/user_avatar/forum.sambapos.com/emre/32/39073_2.png) [@emre](https://forum.sambapos.com/u/emre)\
**Post date:** [December 19, 2018, 5:09pm UTC](https://forum.sambapos.com/t/p-l-report-no-longer-grouping-in-latest-version/18995/3 "2018-12-19T17:09:14Z")

</div>

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.