I'm trying to replicate the

When Ordered By Field

concept within a saved search formula but having issues getting something that doesn't either give me

ERROR: Invalid Expression

for the column or throw an unexpected error on the search as a whole. The general concept is to identify the status/projected total/etc. of the most recently created transaction for a given contact of a few different types, all within the same search. Is there a function that I'm overlooking or is this just not something that saved search formulas can do?

You've probably come up against the limit of what you can do in a saved search. I'm sure it's possible - but you'll have to torture it to do it.

Yeah, that was what I was beginning to think. I was hoping to consolidate the results for processing in a M/R script but I think can just run a few separate searches to get the same combined info in

getInputData

. Less clean than I was hoping but it should get me to the same result at least.