"Lookup" and "maxrow" does not work

[luuthieuky]

Hi there

l don't know how to use it right with this formula:

1. I have a table called "Leave Application" with row "Email" of users, "Datetime", "ID" of each application for leave of users (one user can apply for many leaves). Also one column called "Total available leave days"  (decimal) reflects the number of leave days each users have left. 

2. I want to ask the app to look for the latest row of "Datetime" and get the data in "Total available leave days" fill in an X column with this but it does not work:

LOOKUP(MAXROW("LEAVE APPLICATION","DATETIME",([_THISROW].[EMAIL]=[EMAIL])),"LEAVE APPLICATION","ID","TOTAL AVAILABLE LEAVE DAYS")

How should I fix this? Love to receive your advices.

Many thanks in advance.  

[Tommy62]

Wie bekomme ich einen Spaltenwert nur aus der letzten Zeile dieses Dings?

LOOKUP(
  MAX(
    SELECT(
      My Table[_ROWNUMBER],
      ([_THISROW].[Thing] = [Thing])
    )
  ),
  "My Table",
  "_ROWNUMBER",
  "Wanted Column"
)

Ersetzen Sie durch den Namen der Tabelle, aus der Sie den Spaltenwert verwenden möchten. mit dem Namen der Spalte, die einen Wert enthält, der das gewünschte Objekt identifiziert (z. B. ); und mit dem Namen der Spalte, deren Wert Sie möchten.Meine TableThingOrder-IDWanted-Spalte

[luuthieuky]

The formula works but when I press "Test" it does not show anything. 😞

[New_To_Appsheet]

Thank you Tommy62! I had the same problem and this was the perfect solution! I was using the wrong column in "...SELECT(TABLE[COLUMN]..." Thank you again!