Solved: Combine Top(sort(select(Datetime))) expressions to... - Page 2

Chinh · 02-19-2021 10:43 AM

hi, I’m new to the community and hopping to get some pointers from the pros.
I have a “customer” table w [customer ID] key and 3 other tables linked to that key “repair orders”, “Sale orders”, “device Buy-in” (also each of those 3 tables has its own [datetime] column.
Now I’m trying to get a formula for a column called [Customer since] in the “Customer table”. the formula is to tell Appsheet to put together all the corresponding datetimes of all the transactions (from those 3 tables) that related to a specific customer ID and sort them out and finally give out the earliest result
I’ve been trying that by combining these expressions together TOP(), SORT(), SELLECT() but none seems to work correctly so far.
Could someone please point me to the right direction?

Steve

LIST() shouldn’t be there at all. Try without it:

MIN((Select(ServiceOrdersSL[Date],[Customer ID]=[_THISROW].[Customer ID]) +
Select(DeviceSaleSL[Picked up],[Customer ID]=[_THISROW].[Customer ID]) +
Select(DeviceBuyinSL[Buy-in Date],[Seller’s ID]=[_THISROW].[Customer ID])
))

View solution in original post

Combine Top(sort(select(Datetime))) expressions together