Solved: I'm trying to order a SELECT list by another - Page 2

Simon_Bailey · 12-13-2018 04:00 PM

I’m trying to order a SELECT list by another column (date) but I’m obviously doing it wrong.

This expression gives me the first thing in the list: =TOP(SELECT(MOULDING BOX MOVEMENTS[MOVED TO],[Product Code on Overstock]=[_THISROW].[Product Code on Overstock]),1)

But I want the first thing based in the date: Have tried this =TOP(ORDERBY(SELECT(MOULDING BOX MOVEMENTS[MOVED TO],[Product Code on Overstock]=[_THISROW].[Product Code on Overstock]),[Date Received]),1)

But it says ORDERBY has invalid inputs

Am I totally wrong, or close?

Steven_Coile

This should get you the desired row:

MINROW(“MOULDING BOX MOVEMENTS”, “Date Received”, ([Product Code on Overstock] = [_THISROW].[Product Code on Overstock]))

If you use that as the app formula for a virtual column, you could then get the MOVED TO column value via the virtual column:

[My VirtCol].[MOVED TO]

Would that be adequate?

View solution in original post