How to get Max of a Dataset column

AI generated answer (using internal Slack threads):

To get the maximum value of a dataset column in NetSuite, you can use the MAX SQL function in a saved search. This function will return the largest value for that column across all records returned by the search criteria. Here's a general example of how you can use the MAX function: 1. Create a new saved search. 2. In the Criteria tab, define the criteria for the records you want to search. 3. In the Results tab, add a new column. 4. In the new column, select Formula (Numeric) as the type. 5. In the Formula field, enter

MAX({field})

, replacing

field

with the internal ID of the field you want to find the maximum value of. 6. Set the Summary Type to Maximum. Please note that the behavior of the MAX function depends on how NetSuite generates the GROUP BY statement. If you're not using a GROUP BY statement, the MAX function will return the largest value for the specified column across all records returned by the search criteria. If you're using a GROUP BY statement, the MAX function will return the largest value for each group of records. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

I asked about datasets, not saved searches

Thank you for your feedback