= MIN ({shipdate}) over(partition by {internalid} ORDER BY {line} ASC) how to use this in a summary saved search

AI generated answer (using internal Slack threads):

The use of

MIN

function in a summary saved search in NetSuite is a bit tricky. The

MIN

function is not directly supported in the formula fields of a summary saved search. However, you can use the

GROUP

or

MAX

summary type to perform calculations on summed formulas. Here's how you can use it: 1. Create a new summary saved search. 2. In the criteria section, add your conditions. 3. In the results section, add a new field with the following details: - Field: Formula (Numeric) - Summary Type: Group or Max - Formula:

{shipdate}

This will give you the minimum shipdate for each group defined by the internalid. However, please note that the

ORDER BY

clause is not directly supported in the saved search formula fields. You might need to sort the results manually after the search is executed. Also, the

PARTITION BY

clause is not directly supported in NetSuite saved searches. You might need to create separate searches or use scripting to achieve similar results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******