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?
User | Count |
---|---|
18 | |
11 | |
7 | |
4 | |
3 |