can a saved search field return the smallest value of a partition

AI generated answer (using internal Slack threads):

In NetSuite Saved Searches, you can use aggregate functions like SUM, MAX, MIN, AVG, etc. However, these functions are typically used in the Results tab of the Saved Search, not in the Criteria tab. In the context of your question, if you're trying to return the smallest value of a partition, you might be thinking of something similar to the SQL functionality of

MIN() OVER (PARTITION BY...)

. Unfortunately, NetSuite Saved Searches do not support this kind of window function directly. However, you can achieve similar results by using a combination of grouping and summary types. For example, you can group by the field you want to partition by, and then use the MIN summary type on the field you want to get the smallest value of. This will return the smallest value for each group. Please note that the use of aggregate functions like MIN or MAX in the formula field of a saved search is limited. They only work if you have a SUM, MAX, or MIN summary type. If you're looking for pulling either the largest or smallest value between a set of values, you could try out the functions GREATEST or LEAST. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

importing tax groups