I tried using this formula
CASE WHEN rownum < = 100 THEN 1 ELSE 0 END
Which unfortunately returns the first found 100 results and then NetSuite sorts the values. So if I'm trying to sort by amount descending I get the first 100 results sorted by amount and not the top 100 of all results.
Is there a way to achieve what I'm trying to do with a SavedSearch?