in Suite Analytics how to count number of rows using a formula field

AI generated answer (using internal Slack threads):

In SuiteAnalytics, you can count the number of rows using a formula field by creating a Formula (Numeric) field with just

1

as the formula. This will assign a value of 1 to each row in your search results. Then, you can use the SUM function at the end in the standard/default total row to get the total count of rows. Here are the steps to do this: 1. Go to the SuiteAnalytics tab in NetSuite. 2. Create a new search or edit an existing one. 3. In the Results tab, click on the 'New Formula' button. 4. Select 'Numeric' as the Formula Type. 5. In the Formula field, simply enter

1

. 6. Click on 'Validate' to make sure the formula is valid. 7. Save your search. Now, each row in your search results will have a value of 1 in this new column. The SUM function in the total row will then give you the total count of rows. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******