How to add two fields to get the total number of r...
# ask-stanley-ai
d
How to add two fields to get the total number of records in saved search?
c
AI generated answer (using internal Slack threads):
To add two fields to get the total number of records in a saved search, you can use the 'Summary Type' feature in NetSuite's saved search. Here are the steps: 1. Go to your saved search and click on the 'Results' tab. 2. In the 'Results' tab, you will see a list of fields that are currently being displayed in your saved search. 3. Click on the 'Add Field' button to add a new field to the search. 4. In the 'Field' dropdown, select the field you want to add. 5. In the 'Summary Type' dropdown, select 'Sum'. This will sum up the values of the selected field across all records returned by the search. 6. Repeat steps 3-5 for the second field you want to add. 7. Click 'Save & Run' to see the updated search results with the total sum of the two fields. Please note that the 'Summary Type' feature is only available for fields that contain numeric data. If you are trying to sum up fields that contain non-numeric data, you will need to convert the data to a numeric format first. Also, if you want to see the sum for each group (for example, sum of each sales order), you can set the 'Group' option in the 'Summary Type' dropdown. This will group the records by the selected field and display the sum for each group. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.845318198
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835523784
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.834051788
Please provide your feedback on this answer.