Little Brain Help

AppSheet AppSheet Q&A
,
1

Hello Everyone,

Im having a little delemma, I just cant figure it out, I think it is just a simple slice,

Im looking to take a table of lot numbers with a virtual column that is always calculating the stock of the lot, and take away all the duplicate rows as seen below, I dont know what wrong atm, tried allot of things.

2X_9_9bfbdb5cd1920879ecf2072c1315d83b9eafc2ed.png
2X_9_9bfbdb5cd1920879ecf2072c1315d83b9eafc2ed.png768Ă—466 17.8 KB

I just want to get all the duplicate rows of Lot Number. So im only showing an overview of the final results. 1 row, per lot number.

2

Set the slice row filter expression to:

(
  [_THISROW]
  = MINROW(
    "My Table",
    "_ROWNUMBER",
    ([_THISROW].[Lot Number] = [Lot Number])
  )
)

Replacing My Table with the name of the table and Lot Number with the name of the lot number column.

7 Likes
3

Amazing. perfect thank you. Would never have figured this out.

3 Likes
4

What the expression does: Find the row number of the first row with the current row’s lot number. Is the current row that first row? If so, add it to the slice.

3 Likes
5

Amazing Thinking. Beautiful lol. I honestly had a huge chain of actions set up and different tables etc. was making it way to complicated. than deleted everything and was trying “Hoping” I could Figure it out with a slice and than there is Steve. @Steve

3 Likes