Can't remove duplicates from list generated from template Start expression

Good Day,

I am attempting to create a template that SUMS up list of the SKUs made for a specific Lot. I have tried several iterations of the Start expression with no luck.

See a generic dereference start expression below

<<Start: [Related Packagings]>>

<<SUM(SELECT(Packaging[E_QTY_EA],(AND([Product]=[_THISROW-1].[Product],[Lot#]=[_THISROW-1].[Lot#])),TRUE))>>

<<End>>

Output
1,080
1,080
2,520
2,520
2,520
2,520
2,520
2,520

The output is basically what I want except no duplicates, how can I remove them?

0 8 434
8 REPLIES 8
Top Labels in this Space