you want to simulate the "maximum when ordered by" thing that you can do in the UI, which NetSuite says is like the

KEEP DENSE_RANK

function (SuiteAnswers 20995) I've used something like this

MIN({systemnote.value}) KEEP (DENSE_RANK LAST ORDER BY {systemnote.date})