Initial value WHERE something, something

tkeats
Participant I

I have a table called Mileage that allows users to record their daily start and stop odometer reading. I created a virtual column called MostRecent that grabs the last entry based in a timestamp: MAXROW(Mileage, Timestamp)

This is so I can set the initial value of the odometer start with MostRecent (yesterdayโ€™s end reading) Itโ€™s working but I need it to look for the current userโ€™s last entryโ€ฆ not just the last entry. Is there some kind of WHERE clause I can use when setting my initial value = MostRecent?
My Mileage table has an email field so I like to specify WHERE UserEmail() = Email

Solved Solved
0 2 447
1 ACCEPTED SOLUTION

Steve
Participant V

View solution in original post

2 REPLIES 2

Steve
Participant V

tkeats
Participant I

For anyone seeking a similar solution I creates a virtual column with a REF type called MostRecent with anapp formula:
MAXROW(Mileage.xlsx, Timestamp, ([Driver Name] = Useremail()))

Then auto computed the Odometer Reading End with this:
[MostRecent].[Odometer Reading End]

Top Labels in this Space