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.
LinkedIn
Twitter
