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.
111 Views