Today I learned that you can use MAX SQL function in a saved search mindblow
w
Watz
01/27/2023, 8:21 PM
You mean like a formula that has max({fieldid})+max({field2}) and put it as a summary grouping?
b
borncorp
01/28/2023, 5:31 AM
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.