Today I learned that you can use MAX SQL function ...
# suitescript
b
Today I learned that you can use MAX SQL function in a saved search mindblow
w
You mean like a formula that has max({fieldid})+max({field2}) and put it as a summary grouping?
b
Yeah. maybe. It's a summary search with a Formula Text field with Summary Type maximum and the formula has Max() which internally selects the topmost result. Kinda hard to explain but it's useful in this particular case.