Hi @everyone

AppSheet AppSheet Q&A
1

I want to show the last value of column by inventory id. but it is showing first value. how do i fix it ?

My current formula:

LOOKUP([Inventory ID], “Ordered”, “Inventory ID”, “Price”)

2 
MAX(Select(Ordered[_RowNumber],[Inventory ID]=
  Select(Ordered[Inventory ID],**TRUE**))
))

So you’ve not really given us any info about the columns you have and what they do. But the above says

Select(Ordered[Inventory ID],**TRUE**))

Go and get a list of rows depending on something. “TRUE” means pull in everything so you’ll want to change that. I’m also assuming that [Inventory ID] is the key column.

MAX(Select(Ordered[_RowNumber],[Inventory ID]=

So from the list created above, get me the highest row number and then return just that row. You might want something else other than _RowNumber

Simon

1minManager.com

1 Like
3

inventory id is name of the item and i wanted to find item’s last value by inventory id. and last value is item’s price or something

4

Tty:

ANY(
  SELECT(
    Ordered[Price],
    (
      MAX(
        SELECT(
          Ordered[_ROWNUMBER],
          ([_THISROW].[Inventory ID] = [Inventory ID])
        )
      )
      = [_ROWNUMBER]
    )
  )
)

How do I get a column value from the last row of this thing only?