How to get Max of a Dataset column in a SuiteAnalytics Dataset (not a saved search, and not in suitescript. This is for the dataset UI)

AI generated answer (using internal Slack threads):

To get the maximum of a dataset column in SuiteAnalytics, you can use the

MAX

function in a formula. However, it's important to note that the behavior of the

MAX

function depends on how NetSuite generates the

GROUP BY

statement. If there is no

GROUP BY

statement,

MAX(any_column)

will return the largest value for that column across all records returned by the search criteria. If you are grouping by a specific column, the

MAX

function will return the largest value for each group. Here's a step-by-step guide on how to use the

MAX

function in a formula: 1. Open your dataset in SuiteAnalytics. 2. Click on the column that you want to find the maximum value of. 3. Click on the

Formula

option. 4. In the formula field, type

MAX(column_name)

, replacing

column_name

with the name of your column. 5. Click

Apply

. Please note that this is a general guide and the exact steps may vary depending on your specific dataset and requirements. Remember to break down your formula into its constituent parts and display them separately to ensure everything is working as expected. You can create separate formulas for different parts of your calculation to help troubleshoot any issues. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******